DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on HR_LOOKUPS

Line 3140: FROM hr_lookups hl

3136: ,p_xml_routine out NOCOPY varchar2) IS
3137:
3138: CURSOR get_dadv_custom_xml_code IS
3139: SELECT hl.description
3140: FROM hr_lookups hl
3141: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
3142: AND hl.lookup_code = 'US_DEPOSIT_ADVICE_XML'
3143: AND hl.enabled_flag = 'Y';
3144:

Line 3147: FROM hr_lookups hl

3143: AND hl.enabled_flag = 'Y';
3144:
3145: CURSOR get_arch_che_custom_xml_code IS
3146: SELECT hl.description
3147: FROM hr_lookups hl
3148: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
3149: AND hl.lookup_code = 'US_ARCHIVE_CHECK_XML'
3150: AND hl.enabled_flag = 'Y';
3151:

Line 3154: FROM hr_lookups hl

3150: AND hl.enabled_flag = 'Y';
3151:
3152: CURSOR get_thpty_che_custom_xml_code IS
3153: SELECT hl.description
3154: FROM hr_lookups hl
3155: WHERE hl.lookup_type = 'PAY_CUSTOM_XML_CODE'
3156: AND hl.lookup_code = 'US_THIRD_PARTY_CHECK_XML'
3157: AND hl.enabled_flag = 'Y';
3158: