APPS.PAYPLNK dependencies on PAY_ELEMENT_LINKS_F

Line 2817: l_costable_type pay_element_links_f.costable_type%TYPE :=null;

2813: l_uom pay_input_values_f.uom%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;

Line 2829: l_link_id pay_element_links_f.element_link_id%TYPE :=null;

2825: l_processing_type pay_element_types_f.processing_type%TYPE :=null;
2826: l_cost_allocation_structure
2827: per_business_groups_perf.cost_allocation_structure%TYPE :=null;
2828: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
2829: l_link_id pay_element_links_f.element_link_id%TYPE :=null;
2830: l_user_status pay_batch_lines.batch_line_status%TYPE :=null;
2831: l_user_message pay_message_lines.line_text%TYPE :=null;
2832: --
2833: absence_entry_already_created boolean := false;

Line 2962: , pay_element_links_f el

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
2965: and et.element_type_id = el.element_type_id
2966: and ee.assignment_id = asg.assignment_id

Line 2987: , pay_element_links_f el

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
2990: and et.element_type_id = el.element_type_id
2991: and ee.assignment_id = asg.assignment_id

Line 3773: from pay_element_links_f el

3769: -- The statement below has the business group id index disabled now.
3770: --
3771: select el.costable_type
3772: into l_costable_type
3773: from pay_element_links_f el
3774: where el.element_link_id = l_link_id
3775: and el.business_group_id + 0 = p_business_group_id
3776: and g_line_record.effective_date between el.effective_start_date
3777: and el.effective_end_date;