DBA Data[Home] [Help]

APPS.PER_PAY_PROPOSALS_POPULATE dependencies on PER_PAY_BASES

Line 26: FROM PER_PAY_BASES PPB

22: SELECT fnd_number.canonical_to_number(PGR.MINIMUM)
23: , fnd_number.canonical_to_number(PGR.MAXIMUM)
24: , fnd_number.canonical_to_number(PGR.MID_VALUE)
25: , PRV.RATE_UOM
26: FROM PER_PAY_BASES PPB
27: , PAY_GRADE_RULES_F PGR
28: , PAY_RATES_V PRV
29: , PER_ALL_ASSIGNMENTS_F ASG
30: WHERE ASG.ASSIGNMENT_ID=p_assignment_id

Line 85: , per_pay_bases ppb

81: select fnd_number.canonical_to_number(pev.screen_entry_value)
82: , pee.element_entry_id
83: from pay_element_entry_values_f pev
84: , pay_element_entries_f pee
85: , per_pay_bases ppb
86: , per_all_assignments_f asg
87: where asg.assignment_id=p_assignment_id
88: and NVL(p_change_date,to_date('31-12-4127','DD-MM-YYYY')) between
89: asg.effective_start_date and asg.effective_end_date

Line 312: , PER_PAY_BASES PPB

308: , PET.ELEMENT_TYPE_ID
309: , PIV.UOM
310: FROM PAY_ELEMENT_TYPES_F PET
311: , PAY_INPUT_VALUES_F PIV
312: , PER_PAY_BASES PPB
313: --
314: WHERE PPB.PAY_BASIS_ID=L_PAY_BASIS_ID
315: --
316: AND PPB.INPUT_VALUE_ID=PIV.INPUT_VALUE_ID