DBA Data[Home] [Help]

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 14: pay_assignment_actions paa,

10: 'TRANSMITTER_GRE_ID=P',
11: to_char(hoi.organization_id)
12: FROM
13: pay_payroll_actions ppa,
14: pay_assignment_actions paa,
15: hr_organization_information hoi
16: WHERE
17: ppa.payroll_action_id = paa.payroll_action_id
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'

Line 31: pay_assignment_actions paa,

27: to_char(hoi.organization_id)
28: FROM
29: pay_payroll_actions ppa,
30: pay_payroll_actions ppa1,
31: pay_assignment_actions paa,
32: pay_assignment_actions paa1,
33: pay_action_interlocks int,
34: hr_organization_information hoi
35: WHERE

Line 32: pay_assignment_actions paa1,

28: FROM
29: pay_payroll_actions ppa,
30: pay_payroll_actions ppa1,
31: pay_assignment_actions paa,
32: pay_assignment_actions paa1,
33: pay_action_interlocks int,
34: hr_organization_information hoi
35: WHERE
36: ppa.payroll_action_id = paa.payroll_action_id

Line 61: pay_assignment_actions paa,

57: FROM
58: ff_archive_items fai,
59: ff_database_items fdi,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa,
62: pay_payroll_actions ppa1,
63: pay_assignment_actions paa1,
64: pay_action_interlocks int,
65: hr_organization_information hoi1

Line 63: pay_assignment_actions paa1,

59: ff_database_items fdi,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa,
62: pay_payroll_actions ppa1,
63: pay_assignment_actions paa1,
64: pay_action_interlocks int,
65: hr_organization_information hoi1
66: WHERE paa.payroll_action_id = ppa.payroll_action_id
67: AND hoi1.organization_id = paa1.tax_unit_id

Line 100: pay_assignment_actions paa,

96: FROM
97: per_all_people_f ppf,
98: per_all_assignments_f paf,
99: pay_action_interlocks pai,
100: pay_assignment_actions paa,
101: pay_payroll_actions ppa,
102: pay_assignment_actions paa_mag
103: WHERE
104: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 102: pay_assignment_actions paa_mag

98: per_all_assignments_f paf,
99: pay_action_interlocks pai,
100: pay_assignment_actions paa,
101: pay_payroll_actions ppa,
102: pay_assignment_actions paa_mag
103: WHERE
104: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
105: AND paa.payroll_action_id = ppa.payroll_action_id
106: AND pai.locking_action_id = paa.assignment_action_id