[Home] [Help]
13: SELECT get_parameters(c_payroll_action_id, 'Legal_Employer')
14: ,start_date
15: ,effective_date
16: ,business_group_id
17: FROM pay_payroll_actions
18: WHERE payroll_action_id = c_payroll_action_id;
19: --
20: BEGIN
21: --
37: SELECT SUBSTR(legislative_parameters,
38: INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1),
39: INSTR(legislative_parameters,' ',
40: INSTR(legislative_parameters,p_token_name)))
41: FROM pay_payroll_actions
42: WHERE payroll_action_id = p_payroll_action_id;
43: --
44: l_token_value VARCHAR2(50);
45: --
106:
107: --
108: sqlstr := 'select distinct person_id '||
109: 'from per_people_f ppf, '||
110: 'pay_payroll_actions ppa '||
111: 'where ppa.payroll_action_id = :payroll_action_id '||
112: 'and ppa.business_group_id = ppf.business_group_id '||
113: 'order by ppf.person_id';
114: --
183: AND hr.segment2 = hoi.org_information1
184: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
185: AND hoi.organization_id = decode(c_legal_employer,NULL,hoi.organization_id,c_legal_employer)
186: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
187: FROM pay_payroll_actions appa
188: ,pay_assignment_actions act
189: ,pay_action_information pai
190: WHERE act.assignment_id = asl.assignment_id
191: AND act.payroll_action_id = appa.payroll_action_id
209: ,hr_soft_coding_keyflex hr
210: ,hr_organization_information hoi
211: ,per_absence_attendance_types pat
212: ,per_absence_attendances paa
213: ,pay_payroll_actions ppa
214: where ppa.payroll_action_id = c_p_actid
215: AND asl.person_id BETWEEN stperson AND endperson
216: AND asl.primary_flag = 'Y'
217: AND asl.business_group_id = ppa.business_group_id
226: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
227: AND hoi.organization_id =NVL(c_legal_employer,hoi.organization_id)
228: AND c_end_date between asl.effective_start_date and asl.effective_end_date
229: AND NOT EXISTS (SELECT NULL
230: FROM pay_payroll_actions appa
231: ,pay_assignment_actions act
232: ,pay_action_information pai
233: WHERE act.assignment_id = asl.assignment_id
234: AND act.payroll_action_id = appa.payroll_action_id
240: AND pai.action_information_category = 'ES_CC_REP_EMPLOYEE'
241: AND pai.action_information21 = 'S'
242: AND pai.action_information22 = to_char(paa.absence_attendance_id))
243: AND NOT EXISTS (SELECT NULL
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: WHERE appa.payroll_action_id = c_p_actid
247: AND act.payroll_action_id = appa.payroll_action_id
248: AND act.assignment_id = asl.assignment_id);
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
477: ,hr_soft_coding_keyflex hr
478: ,hr_organization_information hoi
479: WHERE paas.assignment_action_id = p_assactid
480: AND paas.payroll_action_id = ppa.payroll_action_id
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi
527: ,per_absence_attendance_types pat
1041: ,substr(pai4.action_information8,1,15) ecity
1042: ,substr(pai4.action_information10,1,13) eprov_name
1043: ,substr(pai4.action_information12,1,6) epostal_code
1044: ,paa.assignment_action_id
1045: FROM pay_payroll_actions ppa
1046: ,pay_assignment_actions paa
1047: ,pay_action_information pai1 --Employer rec
1048: ,pay_action_information pai2 --Employer Address
1049: ,pay_action_information pai3 --Employee rec