[Home] [Help]
1272: ppa.business_group_id,
1273: ppa.effective_date,
1274: ppa.legislative_parameters,
1275: pbg.legislation_code
1276: from pay_payroll_actions ppa,
1277: per_business_groups_perf pbg
1278: where ppa.payroll_action_id = p_payroll_action_id
1279: and pbg.business_group_id = ppa.business_group_id;
1280: --
1450: end if;
1451: --
1452: p_sqlstr :=
1453: 'select distinct ppos.person_id
1454: from pay_payroll_actions ppa,
1455: per_all_people_f pp,
1456: per_periods_of_service ppos
1457: where ppa.payroll_action_id = :payroll_action_id
1458: and pp.business_group_id = ppa.business_group_id + 0
1511: from pay_jp_itwb_assact_latest_v pjia,
1512: pay_jp_itwb_emp_v pjie,
1513: pay_jp_itwb_emp_si_v pjies,
1514: pay_assignment_actions paa,
1515: pay_payroll_actions ppa
1516: --where ppos.person_id
1517: -- between p_start_person_id and p_end_person_id
1518: where pjia.effective_date
1519: between g_effective_soy and g_effective_eoy
1582: pay_jp_itwb_emp_v pjie,
1583: pay_jp_itwb_emp_si_v pjies,
1584: hr_assignment_set_amendments hasa,
1585: pay_assignment_actions paa,
1586: pay_payroll_actions ppa
1587: --where ppos.person_id
1588: -- between p_start_person_id and p_end_person_id
1589: where pjia.effective_date
1590: between g_effective_soy and g_effective_eoy
2171: pay_jp_itwb_sal_act_erd_v pjisaer,
2172: pay_jp_itwb_bon_act_erd_v pjibaer,
2173: pay_jp_itwb_bon_act_type_v pjibat,
2174: pay_assignment_actions proc_paa,
2175: pay_payroll_actions proc_ppa
2176: where mpaa.payroll_action_id = p_payroll_action_id
2177: and pjia.assignment_id = mpaa.assignment_id
2178: and pjia.effective_date
2179: between g_effective_soy and g_effective_eoy
7514: -- end if;
7515: ----
7516: -- p_sqlstr :=
7517: -- 'select paa.rowid
7518: -- from pay_payroll_actions ppa,
7519: -- pay_assignment_actions paa,
7520: -- pay_jp_itwb_assact_latest_v pjia,
7521: -- pay_jp_itwb_emp_v pjie,
7522: -- pay_jp_itwb_emp_ass_v pjieas