DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on HR_ORGANIZATION_INFORMATION

Line 96: hr_organization_information hoi1,

92: 'FWL_INTEREST=P',
93: pay_sg_cpfline_balances.get_fwl_interest
94: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
95: from hr_organization_units hou,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
98: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
99: and hou.organization_id = hoi1.organization_id(+)
100: and hou.organization_id = hoi2.organization_id

Line 97: hr_organization_information hoi2

93: pay_sg_cpfline_balances.get_fwl_interest
94: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
95: from hr_organization_units hou,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
98: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
99: and hou.organization_id = hoi1.organization_id(+)
100: and hou.organization_id = hoi2.organization_id
101: and hoi1.org_information_context = 'SG_LEGAL_ENTITY'