APPS.HR_JP_ID_PKG dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 1519: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE

1515: p_classification_id IN NUMBER,
1516: p_business_group_id IN NUMBER,
1517: p_legislation_code IN VARCHAR2,
1518: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1519: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE
1520: --------------------------------------------------------------------------------
1521: IS
1522: l_unique_column_tbl UniColTbl;
1523: l_csr RefCsr;

Line 1524: l_rec PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE;

1520: --------------------------------------------------------------------------------
1521: IS
1522: l_unique_column_tbl UniColTbl;
1523: l_csr RefCsr;
1524: l_rec PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE;
1525: BEGIN
1526: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1527: unique_tbl_constructor('CLASSIFICATION_ID','N',to_char(p_classification_id),l_unique_column_tbl);
1528: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);

Line 1530: l_csr := csr('PAY_SUB_CLASSIFICATION_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1526: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1527: unique_tbl_constructor('CLASSIFICATION_ID','N',to_char(p_classification_id),l_unique_column_tbl);
1528: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1529:
1530: l_csr := csr('PAY_SUB_CLASSIFICATION_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1531: fetch l_csr into l_rec;
1532: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1533: l_rec := NULL;
1534: end if;