APPS.HR_JP_ID_PKG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 1428: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_STATUS_PROCESSING_RULES_F%ROWTYPE

1424: p_assignment_status_type_id IN NUMBER DEFAULT NULL,
1425: p_business_group_id IN NUMBER DEFAULT NULL,
1426: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1427: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1428: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_STATUS_PROCESSING_RULES_F%ROWTYPE
1429: --------------------------------------------------------------------------------
1430: IS
1431: l_unique_column_tbl UniColTbl;
1432: l_csr RefCsr;

Line 1433: l_rec PAY_STATUS_PROCESSING_RULES_F%ROWTYPE;

1429: --------------------------------------------------------------------------------
1430: IS
1431: l_unique_column_tbl UniColTbl;
1432: l_csr RefCsr;
1433: l_rec PAY_STATUS_PROCESSING_RULES_F%ROWTYPE;
1434: BEGIN
1435: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1436: unique_tbl_constructor('ASSIGNMENT_STATUS_TYPE_ID','N',to_char(p_assignment_status_type_id),l_unique_column_tbl);
1437: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);

Line 1439: l_csr := csr('PAY_STATUS_PROCESSING_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1435: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1436: unique_tbl_constructor('ASSIGNMENT_STATUS_TYPE_ID','N',to_char(p_assignment_status_type_id),l_unique_column_tbl);
1437: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1438:
1439: l_csr := csr('PAY_STATUS_PROCESSING_RULES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1440: fetch l_csr into l_rec;
1441: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1442: l_rec := NULL;
1443: end if;