eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAYPLNK dependencies on PAY_ELEMENT_TYPES_F

Line 2814: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;

2810: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2811: l_error_text pay_message_lines.line_text%TYPE :=null;
2812: l_input_value_id pay_input_values_f.input_value_id%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;

Line 2824: pay_element_types_f.multiple_entries_allowed_flag%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
2827: per_business_groups_perf.cost_allocation_structure%TYPE :=null;
2828: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;

Line 2825: l_processing_type pay_element_types_f.processing_type%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
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;

Line 2938: pay_element_types_f etp

2934: inv.lookup_type,
2935: inv.value_set_id,
2936: etp.input_currency_code
2937: from pay_input_values_f inv,
2938: pay_element_types_f etp
2939: where inv.element_type_id = l_element_type_id
2940: and etp.element_type_id = l_element_type_id
2941: -- and ((inv.business_group_id +0 = l_business_group_id) OR
2942: -- ((inv.business_group_id IS NULL) AND

Line 2961: , pay_element_types_f et

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

Line 2986: , pay_element_types_f et

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

Line 3177: from pay_element_types_f ET,

3173: select null
3174: into l_dummy
3175: from dual
3176: where exists(select null
3177: from pay_element_types_f ET,
3178: ben_benefit_classifications BCL
3179: where ET.element_type_id = g_line_record.element_type_id
3180: and ET.benefit_classification_id = BCL.benefit_classification_id
3181: and BCL.contributions_used = 'Y');

Line 3256: from pay_element_types_f elt

3252: (g_line_record.element_name is not null) then
3253: begin
3254: select elt.element_type_id -- ,business_group_id -- CWA
3255: into l_element_type_id -- ,l_business_group_id -- CWA
3256: from pay_element_types_f elt
3257: where upper(elt.element_name) = upper(g_line_record.element_name)
3258: and g_line_record.effective_date between elt.effective_start_date
3259: and elt.effective_end_date
3260: and (elt.business_group_id = p_business_group_id

Line 3307: from pay_element_types_f elt

3303: (g_line_record.element_name is not null) then
3304: begin
3305: select 'x' -- ,business_group_id -- CWA
3306: into l_element_exists -- ,l_business_group_id -- CWA
3307: from pay_element_types_f elt
3308: where upper(elt.element_name) = upper(g_line_record.element_name)
3309: and elt.element_type_id = g_line_record.element_type_id
3310: and g_line_record.effective_date between elt.effective_start_date
3311: and elt.effective_end_date

Line 3346: from pay_element_types_f elt

3342: else
3343: begin
3344: select 'x' -- ,business_group_id -- CWA
3345: into l_element_exists -- ,l_business_group_id -- CWA
3346: from pay_element_types_f elt
3347: where elt.element_type_id = g_line_record.element_type_id
3348: and g_line_record.effective_date between elt.effective_start_date
3349: and elt.effective_end_date
3350: and (elt.business_group_id +0 = p_business_group_id

Line 4108: from pay_element_types_f et

4104: select et.multiple_entries_allowed_flag
4105: , et.processing_type
4106: into l_multiple_entries_allowed
4107: , l_processing_type
4108: from pay_element_types_f et
4109: where et.element_type_id =g_line_record.element_type_id
4110: and g_line_record.effective_date between
4111: et.effective_start_date and et.effective_end_date;
4112:

Line 4880: from pay_element_types_f pet,

4876: j number;
4877: --
4878: cursor csr_check_classification is
4879: select 'Y'
4880: from pay_element_types_f pet,
4881: pay_element_classifications pec
4882: where pet.element_type_id = l_line_record.element_type_id
4883: and pet.CLASSIFICATION_ID = pec.CLASSIFICATION_ID
4884: and pet.PROCESSING_TYPE = 'R'