APPS.PAYPLNK dependencies on PAY_ELEMENT_LINKS_F

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

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

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

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

Line 2967: , pay_element_links_f el

2963: , ee.effective_end_date
2964: , ee.effective_start_date
2965: from pay_element_entries_f ee
2966: , pay_element_types_f et
2967: , pay_element_links_f el
2968: , per_all_assignments_f asg
2969: where el.element_link_id = ee.element_link_id
2970: and et.element_type_id = el.element_type_id
2971: and ee.assignment_id = asg.assignment_id

Line 2995: , pay_element_links_f el

2991: l_assignment_id in number) is
2992: select null
2993: from pay_element_entries_f ee
2994: , pay_element_types_f et
2995: , pay_element_links_f el
2996: , per_all_assignments_f asg
2997: where el.element_link_id = ee.element_link_id
2998: and et.element_type_id = el.element_type_id
2999: and ee.assignment_id = asg.assignment_id

Line 3791: from pay_element_links_f el

3787: -- The statement below has the business group id index disabled now.
3788: --
3789: select el.costable_type
3790: into l_costable_type
3791: from pay_element_links_f el
3792: where el.element_link_id = l_link_id
3793: and el.business_group_id + 0 = p_business_group_id
3794: and g_line_record.effective_date between el.effective_start_date
3795: and el.effective_end_date;