APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PAY_ELEMENT_TYPES_F

Line 534: pay_element_types_f pet

530: )
531: IS
532: select pet.element_name||': '||piv.name
533: from pay_input_values_f piv,
534: pay_element_types_f pet
535: where piv.input_value_id = v_input_value_id
536: and piv.element_type_id = v_element_type_id
537: and piv.element_type_id = pet.element_type_id
538: and v_effective_date between piv.effective_start_date and piv.effective_end_date

Line 813: pay_element_types_f pet,

809: SELECT decode(piv.uom,NULL,2,'M',nvl(curr.PRECISION,2),5) PRECISION
810: FROM per_all_assignments_f asg,
811: per_pay_bases ppb,
812: pay_input_values_f piv,
813: pay_element_types_f pet,
814: fnd_currencies curr
815: WHERE asg.assignment_id = v_assignment_id
816: AND v_effective_date BETWEEN asg.effective_start_date
817: AND asg.effective_end_date

Line 2144: from pay_element_types_f pet,

2140: pel.element_type_id,
2141: pev.input_value_id,
2142: pet.element_name,
2143: pet.processing_type
2144: from pay_element_types_f pet,
2145: pay_element_links_f pel,
2146: pay_element_entries_f pee,
2147: pay_element_entry_values_f pev
2148: where pev.element_entry_value_id = p_element_entry_value_id

Line 2959: from pay_element_types_f pet

2955:
2956: cursor c_element_proc_stat(element_id number) is
2957: select pet.element_name,
2958: pet.processing_type
2959: from pay_element_types_f pet
2960: where pet.element_type_id = element_id;
2961: l_element_proc_stat c_element_proc_stat%ROWTYPE;
2962:
2963: --12581640