APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 3066: -- First update for PAY_ELEMENT_ENTRIES_F

3062: -- Mark pay_process_events to process
3063: -- as determined by the date range. The maxmum allowed range
3064: -- is the pension year start date and a day before the current eff date
3065:
3066: -- First update for PAY_ELEMENT_ENTRIES_F
3067: UPDATE pay_process_events ppe
3068: SET ppe.retroactive_status = p_status
3069: ,ppe.status = p_status
3070: WHERE ppe.assignment_id = p_assignment_id

Line 3081: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

3077: AND ppe.surrogate_key = p_element_entry_id
3078: AND EXISTS (SELECT 1
3079: FROM pay_dated_tables pdt
3080: ,pay_event_updates peu
3081: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
3082: AND peu.dated_table_id = pdt.dated_table_id
3083: AND peu.change_type = ppe.change_type
3084: AND peu.event_update_id = ppe.event_update_id
3085: )

Line 5981: from pay_element_entries_f pee

5977: Cursor csr_ele_entries ( c_assignment_id in number
5978: ,c_effective_date in date
5979: ,c_element_type_id in number ) Is
5980: Select pee.element_entry_id
5981: from pay_element_entries_f pee
5982: ,pay_element_links_f pel
5983: where pee.assignment_id = c_assignment_id
5984: and pel.element_link_id = pee.element_link_id
5985: and pel.element_type_id = c_element_type_id

Line 5998: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

5994: l_allowance_code varchar2(1);
5995: l_element_name pay_element_types_f.element_name%TYPE;
5996: l_input_value_name pay_input_values_f.name%TYPE;
5997: l_element_type_id pay_element_types_f.element_type_id%TYPE;
5998: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
5999: l_count_ele_entries Number;
6000: l_return_value char(7) := ' ';
6001: l_error_value number;
6002: l_proc_name varchar2(60) := g_proc_name || 'Get_Allowance_Code';

Line 6316: ,pay_element_entries_f pee

6312: ,p_element_type_id IN NUMBER
6313: ,p_date IN DATE )IS
6314: select 'Y'
6315: from pay_element_links_f pel
6316: ,pay_element_entries_f pee
6317: ,pay_element_types_f pet
6318: where pet.element_type_id = pel.element_type_id
6319: and pel.element_link_id = pee.element_link_id
6320: and pee.assignment_id = p_assignment_id

Line 16787: ,pay_element_entries_f pee

16783:
16784: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS
16785: SELECT pee.element_entry_id
16786: FROM pay_element_links_f pel
16787: ,pay_element_entries_f pee
16788: where pel.element_type_id = p_element_type_id
16789: and p_effective_date between pel.effective_start_date
16790: and pel.effective_end_date
16791: and pee.element_link_id = pel.element_link_id

Line 17315: FROM pay_element_entries_f pee

17311: ,c_effective_date DATE
17312: )
17313: IS
17314: SELECT 'X'
17315: FROM pay_element_entries_f pee
17316: ,pay_element_links_f pel
17317: WHERE pee.assignment_id = c_assignment_id
17318: AND pee.entry_type = 'E'
17319: AND pee.element_link_id = pel.element_link_id