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 500: and per_assignment_extra_info.aei_information6 assignment_type = 'B' (Refer UNIONed-query).

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

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

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

Line 544: per_assignment_extra_info aei,

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

Line 1930: per_assignment_extra_info aei

1926: --
1927: cursor c_per_extra (p_person_id in number) is
1928: select aei.aei_information1
1929: from per_all_assignments_f asg,
1930: per_assignment_extra_info aei
1931: where asg.person_id = p_person_id
1932: and asg.assignment_id = aei.assignment_id
1933: and asg.primary_flag = 'Y'
1934: and asg.assignment_type = 'B'

Line 2442: per_assignment_extra_info aei

2438: select aei.aei_information2 iasd,
2439: aei.aei_information13 idoh,
2440: aei.aei_information3 iohd
2441: from per_all_assignments_f asg,
2442: per_assignment_extra_info aei
2443: where asg.person_id = p_person_id
2444: and asg.assignment_id = aei.assignment_id
2445: and asg.primary_flag = 'Y'
2446: and asg.assignment_type = 'B'