DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on HR_ORGANIZATION_INFORMATION

Line 106: hr_organization_information hoi1,

102: 'FWL_INTEREST=P',
103: pay_sg_cpfline_balances.get_fwl_interest
104: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
105: from hr_organization_units hou,
106: hr_organization_information hoi1,
107: hr_organization_information hoi2
108: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
109: and hou.organization_id = hoi1.organization_id(+)
110: and hou.organization_id = hoi2.organization_id

Line 107: hr_organization_information hoi2

103: pay_sg_cpfline_balances.get_fwl_interest
104: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) fwl_interest
105: from hr_organization_units hou,
106: hr_organization_information hoi1,
107: hr_organization_information hoi2
108: where hou.organization_id = pay_magtape_generic.get_parameter_value('LEGAL_ENTITY_ID')
109: and hou.organization_id = hoi1.organization_id(+)
110: and hou.organization_id = hoi2.organization_id
111: and hoi1.org_information_context = 'SG_LEGAL_ENTITY'