APPS.PAY_PQH_RBC dependencies on PAY_ELEMENT_ENTRIES_F

Line 45: pay_element_entries_f pee,

41:
42: cursor get_pact_de is
43: select ppa.date_earned
44: from pay_payroll_actions ppa,
45: pay_element_entries_f pee,
46: pay_assignment_actions paa
47: where paa.assignment_id=pay_interpreter_pkg.g_asg_id
48: and paa.payroll_action_id=ppa.payroll_action_id
49: and ppa.action_type in ('R','Q')

Line 57: from pay_element_entries_f pee,

53: order by ppa.date_earned desc;
54:
55: cursor get_bg is
56: select distinct business_group_id
57: from pay_element_entries_f pee,
58: per_all_assignments_f paf
59: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
60: and pee.assignment_id=paf.assignment_id
61: and pay_interpreter_pkg.g_effective_date between

Line 71: from pay_element_entries_f pee

67: select 'Y'
68: from dual
69: where exists (
70: select 'Y'
71: from pay_element_entries_f pee
72: ,pqh_criteria_rate_elements pcre
73: ,pqh_rate_matrix_rates_f prmr
74: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
75: and pcre.element_type_id=pee.element_type_id

Line 82: from pay_element_entries_f pee,

78: and pee.effective_end_date >= prmr.effective_start_date
79: and pee.effective_start_date <= prmr.effective_end_date)
80: or exists (
81: Select 'Y'
82: from pay_element_entries_f pee,
83: pqh_criteria_rate_elements pcre,
84: pqh_criteria_rate_factors pcrf,
85: pqh_rate_matrix_rates_f prmr
86: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id