DBA Data[Home] [Help]

APPS.PAY_CA_T4_AMEND_MAG dependencies on HR_ORGANIZATION_INFORMATION

Line 15: hr_organization_information hoi,

11: max(ppa.payroll_action_id),
12: 'SBMT_REF_ID=P',
13: to_char(max(ppa.payroll_action_id))
14: FROM
15: hr_organization_information hoi,
16: pay_payroll_actions ppa,
17: pay_ca_legislation_info pcli,
18: pay_ca_legislation_info pcli1,
19: pay_ca_legislation_info pcli2

Line 49: hr_organization_information hoi1,

45: ff_archive_items fai,
46: ff_database_items fdi,
47: pay_payroll_actions ppa,
48: pay_assignment_actions aa,
49: hr_organization_information hoi1,
50: hr_organization_information hoi2,
51: pay_ca_legislation_info pcli2
52: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
53: AND hoi1.org_information11 = aa.tax_unit_id

Line 50: hr_organization_information hoi2,

46: ff_database_items fdi,
47: pay_payroll_actions ppa,
48: pay_assignment_actions aa,
49: hr_organization_information hoi1,
50: hr_organization_information hoi2,
51: pay_ca_legislation_info pcli2
52: WHERE aa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
53: AND hoi1.org_information11 = aa.tax_unit_id
54: AND hoi1.org_information11 = hoi2.organization_id