APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 12: l_parameter pay_payroll_actions.legislative_parameters%TYPE;

8: p_parameter_string IN VARCHAR2
9: ,p_token IN VARCHAR2
10: ) RETURN VARCHAR2 IS
11: --
12: l_parameter pay_payroll_actions.legislative_parameters%TYPE;
13: l_start_pos NUMBER;
14: l_delimiter VARCHAR2(1);
15: --
16: BEGIN

Line 52: FROM pay_payroll_actions

48: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE'))
49: ,start_date
50: ,effective_date
51: ,business_group_id
52: FROM pay_payroll_actions
53: WHERE payroll_action_id = c_payroll_action_id;
54: --
55: BEGIN
56: --

Line 122: 'pay_payroll_actions ppa '||

118: );
119: --
120: sqlstr := 'select distinct person_id '||
121: 'from per_people_f ppf, '||
122: 'pay_payroll_actions ppa '||
123: 'where ppa.payroll_action_id = :payroll_action_id '||
124: 'and ppa.business_group_id = ppf.business_group_id '||
125: 'order by ppf.person_id';
126: --

Line 180: ,pay_payroll_actions ppa

176: ) IS
177: SELECT assignment_id
178: FROM per_all_assignments_f asl
179: ,per_periods_of_service ppos
180: ,pay_payroll_actions ppa
181: WHERE ppa.payroll_action_id = c_pact_id
182: AND asl.person_id BETWEEN c_stperson AND c_endperson
183: AND asl.primary_flag = 'Y'
184: AND ppos.period_of_service_id = asl.period_of_service_id

Line 192: FROM pay_payroll_actions appa

188: AND nvl(asl.payroll_id,0) = nvl(c_payroll_id,nvl(asl.payroll_id,0))
189: AND ppos.actual_termination_date BETWEEN ppa.start_date
190: AND ppa.effective_date
191: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
192: FROM pay_payroll_actions appa
193: ,pay_assignment_actions act -- Bug Fix 4369797 Changed table order
194: ,pay_action_information pai
195: WHERE appa.action_status = 'C'
196: AND appa.report_type = 'HU_EMP_CERT'