DBA Data[Home] [Help]

APPS.PAY_CA_T4_AMEND_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 16: pay_payroll_actions ppa,

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
20: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')

Line 47: pay_payroll_actions ppa,

43: pcli2.information_value
44: FROM
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

Line 98: pay_payroll_actions ppa,

94: per_all_people_f ppf,
95: per_all_assignments_f paf,
96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch,
100: pay_payroll_actions ppa_arch
101: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
102: AND paa.payroll_action_id = ppa.payroll_action_id

Line 100: pay_payroll_actions ppa_arch

96: pay_action_interlocks pai,
97: pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: pay_assignment_actions paa_arch,
100: pay_payroll_actions ppa_arch
101: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
102: AND paa.payroll_action_id = ppa.payroll_action_id
103: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
104: AND pai.locking_action_id = paa.assignment_action_id