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_ASSIGNMENT_EXTRA_INFO

Line 181: Fetching salary from per_assignment_extra_info.

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.
182: aei_information6 column for 'Benefit Assignment'
183: records (ie. assignment_type = 'B')
184: 16-Dec-2003 ikasire 115.73 Bug: 3315997 When salary is not defined return with NULL
185: 17-Dec-03 vvprabhu 115.74 Added the assignment for g_debug at the start

Line 485: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).

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'
489: -- Bug:3265142 End

Line 515: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).

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,
519: ppb.pay_basis,

Line 529: per_assignment_extra_info aei,

525: asg.assignment_id assignment_id,
526: fnd_date.canonical_to_date(aei.aei_information8) change_date
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

Line 1812: per_assignment_extra_info aei

1808: --
1809: cursor c_per_extra (p_person_id in number) is
1810: select aei.aei_information1
1811: from per_all_assignments_f asg,
1812: per_assignment_extra_info aei
1813: where asg.person_id = p_person_id
1814: and asg.assignment_id = aei.assignment_id
1815: and asg.primary_flag = 'Y'
1816: and asg.assignment_type = 'B'

Line 2322: per_assignment_extra_info aei

2318: select aei.aei_information2 iasd,
2319: aei.aei_information13 idoh,
2320: aei.aei_information3 iohd
2321: from per_all_assignments_f asg,
2322: per_assignment_extra_info aei
2323: where asg.person_id = p_person_id
2324: and asg.assignment_id = aei.assignment_id
2325: and asg.primary_flag = 'Y'
2326: and asg.assignment_type = 'B'