DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_LOCATIONS

Line 1234: FROM hr_locations hl

1230:
1231: /* Cursor for fetching Employer's Address */
1232: CURSOR csr_get_address IS
1233: SELECT address_line_1 || decode(address_line_2,null,null,',') || address_line_2 || decode(postal_code,null,null,',')|| postal_code
1234: FROM hr_locations hl
1235: , hr_organization_units hou /*hr_all_organization_units hou*/
1236: WHERE hl.location_id = hou.location_id
1237: AND hou.organization_id = p_employer_id;
1238: