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 2816: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;

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

Line 2826: pay_element_types_f.multiple_entries_allowed_flag%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;
2824: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2825: l_multiple_entries_allowed
2826: pay_element_types_f.multiple_entries_allowed_flag%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;

Line 2827: l_processing_type pay_element_types_f.processing_type%TYPE :=null;

2823: e_creator_type pay_element_entries_f.creator_type%TYPE :=null;
2824: e_creator_id pay_element_entries_f.creator_id%TYPE :=null;
2825: l_multiple_entries_allowed
2826: pay_element_types_f.multiple_entries_allowed_flag%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;

Line 2942: pay_element_types_f etp

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

Line 2966: , pay_element_types_f et

2962: , ee.creator_id
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

Line 2994: , pay_element_types_f et

2990: l_element_type_id in number,
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

Line 3186: from pay_element_types_f ET,

3182: select null
3183: into l_dummy
3184: from dual
3185: where exists(select null
3186: from pay_element_types_f ET,
3187: ben_benefit_classifications BCL
3188: where ET.element_type_id = g_line_record.element_type_id
3189: and ET.benefit_classification_id = BCL.benefit_classification_id
3190: and BCL.contributions_used = 'Y');

Line 3265: from pay_element_types_f elt

3261: (g_line_record.element_name is not null) then
3262: begin
3263: select elt.element_type_id -- ,business_group_id -- CWA
3264: into l_element_type_id -- ,l_business_group_id -- CWA
3265: from pay_element_types_f elt
3266: where upper(elt.element_name) = upper(g_line_record.element_name)
3267: and g_line_record.effective_date between elt.effective_start_date
3268: and elt.effective_end_date
3269: and (elt.business_group_id = p_business_group_id

Line 3316: from pay_element_types_f elt

3312: (g_line_record.element_name is not null) then
3313: begin
3314: select 'x' -- ,business_group_id -- CWA
3315: into l_element_exists -- ,l_business_group_id -- CWA
3316: from pay_element_types_f elt
3317: where upper(elt.element_name) = upper(g_line_record.element_name)
3318: and elt.element_type_id = g_line_record.element_type_id
3319: and g_line_record.effective_date between elt.effective_start_date
3320: and elt.effective_end_date

Line 3355: from pay_element_types_f elt

3351: else
3352: begin
3353: select 'x' -- ,business_group_id -- CWA
3354: into l_element_exists -- ,l_business_group_id -- CWA
3355: from pay_element_types_f elt
3356: where elt.element_type_id = g_line_record.element_type_id
3357: and g_line_record.effective_date between elt.effective_start_date
3358: and elt.effective_end_date
3359: and (elt.business_group_id +0 = p_business_group_id

Line 4126: from pay_element_types_f et

4122: select et.multiple_entries_allowed_flag
4123: , et.processing_type
4124: into l_multiple_entries_allowed
4125: , l_processing_type
4126: from pay_element_types_f et
4127: where et.element_type_id =g_line_record.element_type_id
4128: and g_line_record.effective_date between
4129: et.effective_start_date and et.effective_end_date;
4130:

Line 4912: from pay_element_types_f pet,

4908: j number;
4909: --
4910: cursor csr_check_classification is
4911: select 'Y'
4912: from pay_element_types_f pet,
4913: pay_element_classifications pec
4914: where pet.element_type_id = l_line_record.element_type_id
4915: and pet.CLASSIFICATION_ID = pec.CLASSIFICATION_ID
4916: and pet.PROCESSING_TYPE = 'R'