APPS.BEN_CWB_POST_PROCESS dependencies on PAY_ELEMENT_TYPES_F

Line 660: pay_element_types_f pet,

656: SELECT decode(piv.uom,NULL,2,'M',nvl(curr.PRECISION,2),5) PRECISION
657: FROM per_all_assignments_f asg,
658: per_pay_bases ppb,
659: pay_input_values_f piv,
660: pay_element_types_f pet,
661: fnd_currencies curr
662: WHERE asg.assignment_id = v_assignment_id
663: AND v_effective_date BETWEEN asg.effective_start_date
664: AND asg.effective_end_date

Line 1066: FROM pay_element_types_f

1062: v_effective_date IN DATE
1063: )
1064: IS
1065: SELECT input_currency_code
1066: FROM pay_element_types_f
1067: WHERE element_type_id = v_element_type_id
1068: AND v_effective_date BETWEEN effective_start_date AND effective_end_date;
1069:
1070: CURSOR c_element_input_value_name(v_input_value_id IN NUMBER,

Line 1079: pay_element_types_f pet

1075: select pet.element_name||': '||piv.name
1076: , processing_type
1077: , input_currency_code
1078: from pay_input_values_f piv,
1079: pay_element_types_f pet
1080: where piv.input_value_id = v_input_value_id
1081: and piv.element_type_id = v_element_type_id
1082: and piv.element_type_id = pet.element_type_id
1083: and v_effective_date between piv.effective_start_date and piv.effective_end_date