DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_PAY_BASES

Line 32: * 11-MAR-02 aprabhak 115.7 added the per_pay_bases to the element

28: * 10-MAR-02 aprabhak 115.6 The salary conversions now uses the newly
29: * developed benutils routine plan_to_basis_
30: * _conversion. Change the position of the
31: * p_preson_id in the process routine.
32: * 11-MAR-02 aprabhak 115.7 added the per_pay_bases to the element
33: * cursor and approved condition to the
34: * salary cursor
35: * 15-MAR-02 aprabhak 115.8 after the pp runs the worksheet access
36: * to RO it the prior access is updateable

Line 658: per_pay_bases ppb,

654: )
655: IS
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

Line 878: , per_pay_bases ppb

874: , asg.pay_basis_id
875: , ppp.proposed_salary_n
876: , ppp.object_version_number
877: FROM per_all_assignments_f asg
878: , per_pay_bases ppb
879: , per_pay_proposals ppp
880: , ben_cwb_person_info per
881: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
882: AND asg.assignment_id = per.assignment_id

Line 911: FROM per_pay_bases bas

907: )
908: IS
909: SELECT ele.element_entry_id
910: ,ele.element_type_id
911: FROM per_pay_bases bas
912: , pay_element_entries_f ele
913: , pay_element_entry_values_f entval
914: WHERE bas.pay_basis_id = v_pay_basis_id
915: AND entval.input_value_id = bas.input_value_id