APPS.PAY_CA_RULES dependencies on HR_LOOKUPS

Line 1321: FROM hr_lookups hl

1317: ,p_xml_routine out NOCOPY varchar2) IS
1318:
1319: CURSOR get_dadv_custom_xml_code IS
1320: SELECT hl.description
1321: FROM hr_lookups hl
1322: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
1323: AND hl.lookup_code = 'CA_DEPOSIT_ADVICE_XML'
1324: AND hl.enabled_flag = 'Y';
1325:

Line 1328: FROM hr_lookups hl

1324: AND hl.enabled_flag = 'Y';
1325:
1326: CURSOR get_arch_che_custom_xml_code IS
1327: SELECT hl.description
1328: FROM hr_lookups hl
1329: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
1330: AND hl.lookup_code = 'CA_ARCHIVE_CHEQUE'
1331: AND hl.enabled_flag = 'Y';
1332:

Line 1335: FROM hr_lookups hl

1331: AND hl.enabled_flag = 'Y';
1332:
1333: CURSOR get_thpty_che_custom_xml_code IS
1334: SELECT hl.description
1335: FROM hr_lookups hl
1336: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
1337: AND hl.lookup_code = 'CA_THIRD_PARTY_CHEQUE'
1338: AND hl.enabled_flag = 'Y';
1339: