DBA Data[Home] [Help]

APPS.PAYPLNK dependencies on PAY_ELEMENT_ENTRIES_F

Line 2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;

2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;
2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;
2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;

Line 2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;

2815: l_lookup_type pay_input_values_f.lookup_type%TYPE :=null;
2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;
2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2823: l_multiple_entries_allowed

Line 2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;

2816: l_value_set_id pay_input_values_f.value_set_id%TYPE :=null;
2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;
2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2823: l_multiple_entries_allowed
2824: pay_element_types_f.multiple_entries_allowed_flag%TYPE :=null;

Line 2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;

2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;
2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;
2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2823: l_multiple_entries_allowed
2824: pay_element_types_f.multiple_entries_allowed_flag%TYPE :=null;
2825: l_processing_type pay_element_types_f.processing_type%TYPE :=null;

Line 2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;

2818: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE:=null;
2819: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE:=null;
2820: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE :=null;
2821: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2822: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2823: l_multiple_entries_allowed
2824: pay_element_types_f.multiple_entries_allowed_flag%TYPE :=null;
2825: l_processing_type pay_element_types_f.processing_type%TYPE :=null;
2826: l_cost_allocation_structure

Line 2960: from pay_element_entries_f ee

2956: , ee.creator_type
2957: , ee.creator_id
2958: , ee.effective_end_date
2959: , ee.effective_start_date
2960: from pay_element_entries_f ee
2961: , pay_element_types_f et
2962: , pay_element_links_f el
2963: , per_all_assignments_f asg
2964: where el.element_link_id = ee.element_link_id

Line 2985: from pay_element_entries_f ee

2981: l_effective_date in date,
2982: l_element_type_id in number,
2983: l_assignment_id in number) is
2984: select null
2985: from pay_element_entries_f ee
2986: , pay_element_types_f et
2987: , pay_element_links_f el
2988: , per_all_assignments_f asg
2989: where el.element_link_id = ee.element_link_id

Line 4853: -- Inserts an element entry into the PAY_ELEMENT_ENTRIES_F table --

4849: -- NAME --
4850: -- payplnk.insert_element_entry PRIVATE PROCEDURE --
4851: -- --
4852: -- DESCRIPTION --
4853: -- Inserts an element entry into the PAY_ELEMENT_ENTRIES_F table --
4854: ----------------------------------------------------------------------
4855: --
4856: procedure insert_element_entry
4857: (

Line 5073: update pay_element_entries_f

5069: --
5070: end loop;
5071:
5072: -- Set the origin of the entry as the batch and its assignment action.
5073: update pay_element_entries_f
5074: set source_id = p_asg_act_id
5075: where element_entry_id = l_element_entry_id;
5076: --
5077:

Line 5104: -- Updates an existing element entry in the PAY_ELEMENT_ENTRIES_F --

5100: -- NAME --
5101: -- payplnk.update_element_entry PRIVATE PROCEDURE --
5102: -- --
5103: -- DESCRIPTION --
5104: -- Updates an existing element entry in the PAY_ELEMENT_ENTRIES_F --
5105: -- table. --
5106: ---------------------------------------------------------------------
5107: --
5108: procedure update_element_entry

Line 5289: update pay_element_entries_f

5285: --
5286: if p_allow_rollback then
5287: --Recurring element of creator type 'H' or 'F' with update and update insert change.
5288: --
5289: update pay_element_entries_f
5290: set creator_id = p_creator_id,
5291: creator_type = p_creator_type,
5292: source_id = p_asg_act_id
5293: where element_entry_id = p_element_entry_id

Line 5300: update pay_element_entries_f

5296: and creator_type in ('H','F');
5297: else
5298: --Non-recurring.
5299: --
5300: update pay_element_entries_f
5301: set creator_id = null,
5302: source_id = null
5303: where element_entry_id = p_element_entry_id
5304: and l_line_record.effective_date between effective_start_date