eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DERIVE_FACTORS dependencies on PER_PAY_PROPOSALS

Line 491: from per_pay_proposals ppp,

487: asg.payroll_id,
488: asg.frequency,
489: asg.assignment_id,
490: ppp.change_date -- Bug:3265142. Added this for order-by clause
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,

Line 499: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'

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'
500: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).
501: */
502: --and asg.assignment_type <> 'C'
503: and asg.assignment_type = 'E'

Line 529: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'

525: between per.effective_start_date
526: and per.effective_end_date
527: and asg.assignment_id = ppp.assignment_id
528: and ppp.change_date <= l_date
529: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'
530: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).
531: */
532: UNION
533: select fnd_number.canonical_to_number(aei.aei_information6) proposed_salary,