APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 33: FROM pay_payroll_actions

29: + LENGTH (p_token)
30: )
31: ),
32: business_group_id bg_id
33: FROM pay_payroll_actions
34: WHERE payroll_action_id = p_pact_id;
35:
36: l_business_group_id NUMBER;
37: l_token_value VARCHAR2 (50);

Line 74: FROM pay_payroll_actions ppa

70:
71: CURSOR csr_p35_process
72: IS
73: SELECT NVL (MIN (ppa.payroll_action_id), 0)
74: FROM pay_payroll_actions ppa
75: WHERE ppa.report_type = 'IEP35'
76: AND ppa.action_status = 'C'
77: AND TO_DATE (
78: pay_ie_p35.get_parameter (

Line 125: pay_payroll_actions ppa

121: p_sqlstr :=
122: ' SELECT distinct asg.person_id
123: FROM per_periods_of_service pos,
124: per_assignments_f asg,
125: pay_payroll_actions ppa
126: WHERE ppa.payroll_action_id = :payroll_action_id
127: AND pos.person_id = asg.person_id
128: AND pos.period_of_service_id = asg.period_of_service_id
129: AND pos.business_group_id = ppa.business_group_id

Line 185: pay_payroll_actions ppa,

181: CURSOR csr_locked_asgs
182: IS
183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
189: hr_soft_coding_keyflex flex

Line 261: pay_payroll_actions ppa_p35,

257: OR l_assignment_set_id IS NULL)
258: AND NOT EXISTS (
259: SELECT 1
260: FROM pay_assignment_actions paa_p35,
261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
265: pay_action_interlocks plock