[Home] [Help]
116: 'SELECT distinct asg.person_id
117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,
119: pay_assignment_actions act,
120: per_assignments_f asg,
121: pay_payrolls_f ppf
122: WHERE ppa.payroll_action_id = :payroll_action_id
123: '||l_consolidation_set_text||'
124: '||l_payroll_text||'
193: FROM pay_payrolls_f ppf,
194: pay_payroll_actions ppa, /* pre-payments and reversals
195: payroll action id */
196: pay_assignment_actions act,
197: per_assignments_f paf
198: WHERE (c_payroll_id is NULL
199: OR ppa.payroll_id = c_payroll_id)
200: AND ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
201: ppa.consolidation_set_id)
247: ppa.effective_date,
248: act.source_action_id,
249: nvl(ppa.start_date,ppa.effective_date)
250: FROM hr_assignment_set_amendments hasa ,
251: per_assignments_f paf ,
252: pay_assignment_actions act ,
253: pay_payroll_actions ppa ,
254: pay_payrolls_f ppf
255: WHERE (c_payroll_id IS NULL
360: CURSOR c_payroll_def (cp_assignment_id IN NUMBER
361: ,cp_effective_date IN DATE) IS
362: SELECT multi_assignments_flag
363: FROM pay_payrolls_f ppf,
364: per_assignments_f paf
365: WHERE paf.payroll_id = ppf.payroll_id
366: AND cp_effective_date BETWEEN paf.effective_start_date
367: AND paf.effective_end_date
368: AND cp_effective_date BETWEEN ppf.effective_start_date
991:
992: CURSOR c_get_emp_name(assigid number) is
993: SELECT pap.full_name
994: ,paf.assignment_number
995: FROM per_assignments_f paf,
996: per_all_people_f pap
997: WHERE paf.assignment_id = assigid
998: AND pap.person_id = paf.person_id;
999:
1619: NULL)
1620: INTO return_val
1621: FROM hr_all_organization_units hou,
1622: hr_locations_all loc,
1623: per_assignments_f paf
1624: WHERE paf.assignment_id = c_assignment_id
1625: AND c_effective_date BETWEEN
1626: paf.effective_start_date AND paf.effective_end_date
1627: AND hou.organization_id = paf.organization_id