eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PQH_RBC dependencies on PAY_INTERPRETER_PKG

Line 47: where paa.assignment_id=pay_interpreter_pkg.g_asg_id

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')
50: and ppa.date_earned >=pay_interpreter_pkg.g_effective_date
51: and ppa.date_earned between pee.effective_start_date and pee.effective_end_date

Line 50: and ppa.date_earned >=pay_interpreter_pkg.g_effective_date

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')
50: and ppa.date_earned >=pay_interpreter_pkg.g_effective_date
51: and ppa.date_earned between pee.effective_start_date and pee.effective_end_date
52: and pee.element_entry_id=pay_interpreter_pkg.g_ee_id
53: order by ppa.date_earned desc;
54:

Line 52: and pee.element_entry_id=pay_interpreter_pkg.g_ee_id

48: and paa.payroll_action_id=ppa.payroll_action_id
49: and ppa.action_type in ('R','Q')
50: and ppa.date_earned >=pay_interpreter_pkg.g_effective_date
51: and ppa.date_earned between pee.effective_start_date and pee.effective_end_date
52: and pee.element_entry_id=pay_interpreter_pkg.g_ee_id
53: order by ppa.date_earned desc;
54:
55: cursor get_bg is
56: select distinct business_group_id

Line 59: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id

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
62: pee.effective_start_date and pee.effective_end_date
63: and pay_interpreter_pkg.g_effective_date between

Line 61: and pay_interpreter_pkg.g_effective_date between

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
62: pee.effective_start_date and pee.effective_end_date
63: and pay_interpreter_pkg.g_effective_date between
64: paf.effective_start_date and paf.effective_end_date;
65:

Line 63: and pay_interpreter_pkg.g_effective_date between

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
62: pee.effective_start_date and pee.effective_end_date
63: and pay_interpreter_pkg.g_effective_date between
64: paf.effective_start_date and paf.effective_end_date;
65:
66: cursor rate_effected is
67: select 'Y'

Line 74: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id

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
76: and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id
77: and prmr.rate_matrix_rate_id=pay_interpreter_pkg.g_object_key
78: and pee.effective_end_date >= prmr.effective_start_date

Line 77: and prmr.rate_matrix_rate_id=pay_interpreter_pkg.g_object_key

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
76: and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id
77: and prmr.rate_matrix_rate_id=pay_interpreter_pkg.g_object_key
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'

Line 86: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id

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
87: and pcre.element_type_id=pee.element_type_id
88: and pcre.criteria_rate_defn_id = pcrf.criteria_rate_defn_id
89: and pcrf.parent_criteria_rate_defn_id = prmr.criteria_rate_defn_id
90: and prmr.rate_matrix_rate_id = pay_interpreter_pkg.g_object_key

Line 90: and prmr.rate_matrix_rate_id = pay_interpreter_pkg.g_object_key

86: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
87: and pcre.element_type_id=pee.element_type_id
88: and pcre.criteria_rate_defn_id = pcrf.criteria_rate_defn_id
89: and pcrf.parent_criteria_rate_defn_id = prmr.criteria_rate_defn_id
90: and prmr.rate_matrix_rate_id = pay_interpreter_pkg.g_object_key
91: and pee.effective_end_date >= prmr.effective_start_date
92: and pee.effective_start_date <= prmr.effective_end_date);
93:
94: l_exists varchar2(1);

Line 136: p_element_entry_id => pay_interpreter_pkg.g_ee_id,

132: end if;
133:
134: /* Added parameter names for bug 6695937 */
135: pqh_rbc_rate_retrieval.determine_rbc_rate(
136: p_element_entry_id => pay_interpreter_pkg.g_ee_id,
137: p_business_group_id => l_bus_grp,
138: p_effective_date => l_date_earned,
139: p_rate_factors => l_rate_factors,
140: p_rate_factor_cnt => l_rate_factor_cnt,

Line 147: if (l_rate_factors(i).rate_matrix_rate_id=pay_interpreter_pkg.g_object_key)

143: p_max_rate => l_max_rate,
144: p_rate => l_rate);
145:
146: for i in 1..l_rate_factor_cnt loop
147: if (l_rate_factors(i).rate_matrix_rate_id=pay_interpreter_pkg.g_object_key)
148: then
149: close get_pact_de;
150: return 'Y';
151: end if;