APPS.PAY_JP_ITWB_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1514: pay_assignment_actions paa,

1510: ppa.effective_date
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

Line 1585: pay_assignment_actions paa,

1581: from pay_jp_itwb_assact_latest_v pjia,
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

Line 1901: select pay_assignment_actions_s.nextval

1897: -- create assact for one year
1898: --
1899: if l_ass_valid then
1900: --
1901: select pay_assignment_actions_s.nextval
1902: into l_assignment_action_id
1903: from dual;
1904: --
1905: hr_nonrun_asact.insact(

Line 2156: from pay_assignment_actions mpaa,

2152: pjibat.col_cnt12 bon_type_cnt12,
2153: pjibat.col_cnt13 bon_type_cnt13,
2154: pjibat.col_cnt14 bon_type_cnt14,
2155: pjibat.col_cnt15 bon_type_cnt15
2156: from pay_assignment_actions mpaa,
2157: pay_jp_itwb_assact_latest_v pjia,
2158: pay_jp_itwb_emp_v pjie,
2159: pay_jp_itwb_emp_si_v pjies,
2160: pay_assignment_actions arch_paa,

Line 2160: pay_assignment_actions arch_paa,

2156: from pay_assignment_actions mpaa,
2157: pay_jp_itwb_assact_latest_v pjia,
2158: pay_jp_itwb_emp_v pjie,
2159: pay_jp_itwb_emp_si_v pjies,
2160: pay_assignment_actions arch_paa,
2161: pay_jp_itwb_itax_org_v pjiio,
2162: pay_jp_itwb_emp_add_v pjiead,
2163: pay_jp_itwb_emp_ass_v pjieas,
2164: pay_jp_itwb_dep_v pjid,

Line 2174: pay_assignment_actions proc_paa,

2170: pay_jp_itwb_bon_act_efd_v pjibaef,
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

Line 7519: -- pay_assignment_actions paa,

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
7523: -- where ppa.payroll_action_id = :pactid