APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 3094: -- First update for PAY_ELEMENT_ENTRIES_F

3090: -- Mark pay_process_events to process
3091: -- as determined by the date range. The maxmum allowed range
3092: -- is the pension year start date and a day before the current eff date
3093:
3094: -- First update for PAY_ELEMENT_ENTRIES_F
3095: UPDATE pay_process_events ppe
3096: SET ppe.retroactive_status = p_status
3097: ,ppe.status = p_status
3098: WHERE ppe.assignment_id = p_assignment_id

Line 3109: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'

3105: AND ppe.surrogate_key = p_element_entry_id
3106: AND EXISTS (SELECT 1
3107: FROM pay_dated_tables pdt
3108: ,pay_event_updates peu
3109: WHERE pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
3110: AND peu.dated_table_id = pdt.dated_table_id
3111: AND peu.change_type = ppe.change_type
3112: AND peu.event_update_id = ppe.event_update_id
3113: )

Line 6009: from pay_element_entries_f pee

6005: Cursor csr_ele_entries ( c_assignment_id in number
6006: ,c_effective_date in date
6007: ,c_element_type_id in number ) Is
6008: Select pee.element_entry_id
6009: from pay_element_entries_f pee
6010: ,pay_element_links_f pel
6011: where pee.assignment_id = c_assignment_id
6012: and pel.element_link_id = pee.element_link_id
6013: and pel.element_type_id = c_element_type_id

Line 6026: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

6022: l_allowance_code varchar2(1);
6023: l_element_name pay_element_types_f.element_name%TYPE;
6024: l_input_value_name pay_input_values_f.name%TYPE;
6025: l_element_type_id pay_element_types_f.element_type_id%TYPE;
6026: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
6027: l_count_ele_entries Number;
6028: l_return_value char(7) := ' ';
6029: l_error_value number;
6030: l_proc_name varchar2(60) := g_proc_name || 'Get_Allowance_Code';

Line 6344: ,pay_element_entries_f pee

6340: ,p_element_type_id IN NUMBER
6341: ,p_date IN DATE )IS
6342: select 'Y'
6343: from pay_element_links_f pel
6344: ,pay_element_entries_f pee
6345: ,pay_element_types_f pet
6346: where pet.element_type_id = pel.element_type_id
6347: and pel.element_link_id = pee.element_link_id
6348: and pee.assignment_id = p_assignment_id

Line 17156: ,pay_element_entries_f pee

17152:
17153: CURSOR c_element_entry(p_element_type_id IN NUMBER) IS
17154: SELECT pee.element_entry_id
17155: FROM pay_element_links_f pel
17156: ,pay_element_entries_f pee
17157: where pel.element_type_id = p_element_type_id
17158: and p_effective_date between pel.effective_start_date
17159: and pel.effective_end_date
17160: and pee.element_link_id = pel.element_link_id

Line 17684: FROM pay_element_entries_f pee

17680: ,c_effective_date DATE
17681: )
17682: IS
17683: SELECT 'X'
17684: FROM pay_element_entries_f pee
17685: ,pay_element_links_f pel
17686: WHERE pee.assignment_id = c_assignment_id
17687: AND pee.entry_type = 'E'
17688: AND pee.element_link_id = pel.element_link_id