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.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1030: from pay_element_entry_values_f peevf,

1026: begin
1027:
1028: select peevf.screen_entry_value * l_period_frequency
1029: into g_assignments_table(l_assignment.assignment_id).annual_income
1030: from pay_element_entry_values_f peevf,
1031: pay_element_entries_f peef
1032: where peef.assignment_id = l_assignment.assignment_id
1033: and p_report_date between peef.effective_start_date and peef.effective_end_date
1034: and peevf.element_entry_id = peef.element_entry_id

Line 4665: ,l_input_id pay_element_entry_values_f.input_value_id%type) is

4661: order BY paei.aei_information7, paaf.payroll_id;
4662:
4663:
4664: cursor c_ele_rem(l_assignment_id per_all_assignments_f.assignment_id%type
4665: ,l_input_id pay_element_entry_values_f.input_value_id%type) is
4666: select peevf.screen_entry_value screen_value,
4667: months_between(least(peevf.effective_end_date ,p_report_date),greatest(peevf.effective_start_date-1 ,add_months(p_report_date,-12))) months_bet
4668: from pay_element_entry_values_f peevf
4669: ,pay_element_entries_f peef

Line 4668: from pay_element_entry_values_f peevf

4664: cursor c_ele_rem(l_assignment_id per_all_assignments_f.assignment_id%type
4665: ,l_input_id pay_element_entry_values_f.input_value_id%type) is
4666: select peevf.screen_entry_value screen_value,
4667: months_between(least(peevf.effective_end_date ,p_report_date),greatest(peevf.effective_start_date-1 ,add_months(p_report_date,-12))) months_bet
4668: from pay_element_entry_values_f peevf
4669: ,pay_element_entries_f peef
4670: where peef.assignment_id = l_assignment_id
4671: and peevf.element_entry_id = peef.element_entry_id
4672: and peevf.input_value_id = l_input_id

Line 6057: ,l_input_id pay_element_entry_values_f.input_value_id%type) is

6053: order BY paei.aei_information7, paaf.payroll_id;
6054:
6055:
6056: cursor c_ele_rem(l_assignment_id per_all_assignments_f.assignment_id%type
6057: ,l_input_id pay_element_entry_values_f.input_value_id%type) is
6058: select peevf.screen_entry_value screen_value,
6059: months_between(least(peevf.effective_end_date ,p_report_date),greatest(peevf.effective_start_date-1 ,add_months(p_report_date,-12))) months_bet
6060: from pay_element_entry_values_f peevf
6061: ,pay_element_entries_f peef

Line 6060: from pay_element_entry_values_f peevf

6056: cursor c_ele_rem(l_assignment_id per_all_assignments_f.assignment_id%type
6057: ,l_input_id pay_element_entry_values_f.input_value_id%type) is
6058: select peevf.screen_entry_value screen_value,
6059: months_between(least(peevf.effective_end_date ,p_report_date),greatest(peevf.effective_start_date-1 ,add_months(p_report_date,-12))) months_bet
6060: from pay_element_entry_values_f peevf
6061: ,pay_element_entries_f peef
6062: where peef.assignment_id = l_assignment_id
6063: and peevf.element_entry_id = peef.element_entry_id
6064: and peevf.input_value_id = l_input_id