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 476: from per_pay_proposals ppp,

472: asg.payroll_id,
473: asg.frequency,
474: asg.assignment_id,
475: ppp.change_date -- Bug:3265142. Added this for order-by clause
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,

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

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'
485: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).
486: */
487: --and asg.assignment_type <> 'C'
488: and asg.assignment_type = 'E'

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

510: between per.effective_start_date
511: and per.effective_end_date
512: and asg.assignment_id = ppp.assignment_id
513: and ppp.change_date <= l_date
514: /* Bug:3265142 Start: Fetching salary from per_pay_proposals for assignment_type = 'E'
515: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).
516: */
517: UNION
518: select fnd_number.canonical_to_number(aei.aei_information6) proposed_salary,