APPS.PAY_JP_ITWB_REPORT_PKG dependencies on PAY_JP_ITWB_ASSACT_LATEST_V

Line 1511: from pay_jp_itwb_assact_latest_v pjia,

1507: pjie.person_id,
1508: pjia.assignment_id,
1509: pjia.assignment_action_id,
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

Line 1581: from pay_jp_itwb_assact_latest_v pjia,

1577: pjia.assignment_id,
1578: pjia.assignment_action_id,
1579: ppa.effective_date,
1580: hasa.include_or_exclude
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,

Line 2157: pay_jp_itwb_assact_latest_v pjia,

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,
2161: pay_jp_itwb_itax_org_v pjiio,

Line 7520: -- pay_jp_itwb_assact_latest_v pjia,

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
7524: -- and paa.payroll_action_id = ppa.payroll_action_id