APPS.PAY_MX_PAYREG_PKG dependencies on HR_GENERAL

Line 78: ,hr_general.decode_organization(tax_unit_id)

74: SELECT DISTINCT 'ROOT_GRE_TAG=P'
75: ,''
76: ,'TRANSFER_GRE_ID=P'
77: ,tax_unit_id
78: ,hr_general.decode_organization(tax_unit_id)
79: ,'PAYROLL_ACTION_ID=P'
80: ,pay_magtape_generic.get_parameter_value(
81: 'TRANSFER_PAYROLL_ACTION_ID')
82: FROM pay_assignment_actions

Line 85: ORDER BY hr_general.decode_organization(tax_unit_id);

81: 'TRANSFER_PAYROLL_ACTION_ID')
82: FROM pay_assignment_actions
83: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
84: 'TRANSFER_PAYROLL_ACTION_ID')
85: ORDER BY hr_general.decode_organization(tax_unit_id);
86:
87: CURSOR GET_XML_VER IS
88: SELECT 'ROOT_XML_TAG=P'
89: ,''