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 647: per_pay_bases ppb,

643: )
644: IS
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

Line 866: , per_pay_bases ppb

862: , asg.pay_basis_id
863: , ppp.proposed_salary_n
864: , ppp.object_version_number
865: FROM per_all_assignments_f asg
866: , per_pay_bases ppb
867: , per_pay_proposals ppp
868: , ben_cwb_person_info per
869: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
870: AND asg.assignment_id = per.assignment_id

Line 899: FROM per_pay_bases bas

895: )
896: IS
897: SELECT ele.element_entry_id
898: ,ele.element_type_id
899: FROM per_pay_bases bas
900: , pay_element_entries_f ele
901: , pay_element_entry_values_f entval
902: WHERE bas.pay_basis_id = v_pay_basis_id
903: AND entval.input_value_id = bas.input_value_id