DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE dependencies on HR_ORGANIZATION_UNITS

Line 105: from hr_organization_units hou,

101: (pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')) cpf_interest,
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(+)