DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on PAY_ALL_PAYROLLS_F

Line 177: 24-Sep-2003 ikasire 115.71 Bug 3151737 - made the join to pay_all_payrolls_f

173: The same chk has been added to all cursors
174: using per_contact_relationships
175: 14-JUL-2003 glingapp 115.70 added outer join on per_periods_of_service in
176: cursor c_person of determine_los
177: 24-Sep-2003 ikasire 115.71 Bug 3151737 - made the join to pay_all_payrolls_f
178: as outer join and added the effective date
179: clause for the same table.
180: 25-Nov-2003 bmanyam 115.72 Bug:3265142. Changed the cursor c_stated_salary.
181: Fetching salary from per_assignment_extra_info.

Line 495: pay_all_payrolls_f paf,

491: from per_pay_proposals ppp,
492: -- per_assignments_f asg,
493: per_all_assignments_f asg,
494: per_pay_bases ppb,
495: pay_all_payrolls_f paf,
496: per_all_people_f per
497: where per.person_id = p_person_id
498:
499: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'

Line 546: pay_all_payrolls_f paf,

542: from --per_assignments_f asg,
543: per_all_assignments_f asg,
544: per_assignment_extra_info aei,
545: per_pay_bases ppb,
546: pay_all_payrolls_f paf,
547: per_all_people_f per
548: where per.person_id = p_person_id
549: and asg.assignment_type = 'B'
550: and asg.person_id = per.person_id