APPS.PAY_JP_DEF_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 49: from pay_payroll_actions ppa,

45: ppa.business_group_id,
46: ppa.effective_date,
47: ppa.legislative_parameters,
48: pbg.legislation_code
49: from pay_payroll_actions ppa,
50: per_business_groups_perf pbg
51: where ppa.payroll_action_id = g_payroll_action_id
52: and pbg.business_group_id = ppa.business_group_id;
53: --

Line 60: from pay_payroll_actions ppa,

56: select /*+ ORDERED */
57: ppa.business_group_id,
58: ppa.effective_date,
59: pbg.legislation_code
60: from pay_payroll_actions ppa,
61: per_business_groups_perf pbg
62: where ppa.payroll_action_id = g_arch_payroll_action_id
63: and pbg.business_group_id = ppa.business_group_id;
64: --

Line 257: from pay_payroll_actions ppa,

253: end if;
254: --
255: p_sqlstr :=
256: 'select distinct ppos.person_id
257: from pay_payroll_actions ppa,
258: per_all_people_f pp,
259: per_periods_of_service ppos
260: where ppa.payroll_action_id = :payroll_action_id
261: and pp.business_group_id = ppa.business_group_id + 0

Line 2887: -- from pay_payroll_actions ppa,

2883: -- end if;
2884: ----
2885: -- p_sqlstr :=
2886: -- 'select paa.rowid
2887: -- from pay_payroll_actions ppa,
2888: -- pay_assignment_actions paa,
2889: -- pay_jp_def_assact_v pjda,
2890: -- pay_jp_def_emp_v pjde
2891: -- where ppa.payroll_action_id = :pactid