APPS.HRI_OPL_WMV dependencies on PAY_PAYROLL_ACTIONS

Line 99: FROM pay_payroll_actions ppa

95: ,g_collect_to_date
96: ,g_full_refresh
97: ,g_collect_fte
98: ,g_collect_head
99: FROM pay_payroll_actions ppa
100: WHERE payroll_action_id = p_payroll_action_id;
101:
102: END IF;
103:

Line 162: ,pay_payroll_actions ppa

158: 'SELECT DISTINCT
159: asg.person_id
160: FROM
161: per_all_assignments_f asg
162: ,pay_payroll_actions ppa
163: WHERE ppa.payroll_action_id = :payroll_action_id
164: AND asg.assignment_type = ''E''
165: AND (ppa.start_date
166: BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 183: ,pay_payroll_actions ppa

179: 'SELECT DISTINCT
180: asg.person_id
181: FROM
182: per_all_assignments_f asg
183: ,pay_payroll_actions ppa
184: WHERE ppa.payroll_action_id = :payroll_action_id
185: AND asg.assignment_type = ''E''
186: AND (asg.effective_start_date
187: BETWEEN ppa.start_date AND ppa.effective_date

Line 1247: FROM pay_payroll_actions

1243: l_schema VARCHAR2(400);
1244: --
1245: CURSOR wmv_pact_id_csr IS
1246: SELECT payroll_action_id
1247: FROM pay_payroll_actions
1248: WHERE report_qualifier = 'HRI_MB_WMV'
1249: AND report_type = 'HISTORIC_SUMMARY'
1250: AND action_type = 'X';
1251: --