APPS.BEN_CWB_POST_PROCESS dependencies on PAY_ELEMENT_TYPES_F

Line 649: pay_element_types_f pet,

645: SELECT decode(piv.uom,NULL,2,'M',nvl(curr.PRECISION,2),5) PRECISION
646: FROM per_all_assignments_f asg,
647: per_pay_bases ppb,
648: pay_input_values_f piv,
649: pay_element_types_f pet,
650: fnd_currencies curr
651: WHERE asg.assignment_id = v_assignment_id
652: AND v_effective_date BETWEEN asg.effective_start_date
653: AND asg.effective_end_date

Line 1053: FROM pay_element_types_f

1049: v_effective_date IN DATE
1050: )
1051: IS
1052: SELECT input_currency_code
1053: FROM pay_element_types_f
1054: WHERE element_type_id = v_element_type_id
1055: AND v_effective_date BETWEEN effective_start_date AND effective_end_date;
1056:
1057: CURSOR c_element_input_value_name(v_input_value_id IN NUMBER,

Line 1066: pay_element_types_f pet

1062: select pet.element_name||': '||piv.name
1063: , processing_type
1064: , input_currency_code
1065: from pay_input_values_f piv,
1066: pay_element_types_f pet
1067: where piv.input_value_id = v_input_value_id
1068: and piv.element_type_id = v_element_type_id
1069: and piv.element_type_id = pet.element_type_id
1070: and v_effective_date between piv.effective_start_date and piv.effective_end_date