APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1031: pay_element_entries_f peef

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
1035: and peevf.input_value_id = l_input_value_id

Line 4669: ,pay_element_entries_f peef

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
4673: and (add_months(p_report_date,-12)+1 <=peef.effective_end_date and p_report_date>=peef.effective_start_date)

Line 6061: ,pay_element_entries_f peef

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
6065: and (add_months(p_report_date,-12)+1 <=peef.effective_end_date and p_report_date>=peef.effective_start_date)