DBA Data[Home] [Help]

APPS.PAY_NO_TAX_LEVY dependencies on HR_GENERAL

Line 576: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code

572: cursor csr_third_party_loc (p_organization_id NUMBER) is
573: select loc.address_line_1 line_1
574: ,loc.address_line_2 line_2
575: ,loc.address_line_3 line_3
576: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code
577: from hr_locations_all loc
578: ,hr_all_organization_units hou
579: where hou.organization_id = p_organization_id
580: and loc.location_id = hou.location_id