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 480: pay_all_payrolls_f paf,

476: from per_pay_proposals ppp,
477: -- per_assignments_f asg,
478: per_all_assignments_f asg,
479: per_pay_bases ppb,
480: pay_all_payrolls_f paf,
481: per_all_people_f per
482: where per.person_id = p_person_id
483:
484: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'

Line 531: pay_all_payrolls_f paf,

527: from --per_assignments_f asg,
528: per_all_assignments_f asg,
529: per_assignment_extra_info aei,
530: per_pay_bases ppb,
531: pay_all_payrolls_f paf,
532: per_all_people_f per
533: where per.person_id = p_person_id
534: and asg.assignment_type = 'B'
535: and asg.person_id = per.person_id