APPS.PAY_RETRO_NOTIF_PKG dependencies on PER_ASSIGNMENTS_F

Line 268: FROM per_assignments_f paf

264: SELECT astTL.user_status
265: , ppf.full_name
266: INTO l_asg_status
267: , l_person_name
268: FROM per_assignments_f paf
269: , per_assignment_status_types ast
270: , per_assignment_status_types_tl astTL
271: , per_people_f ppf
272: WHERE paf.assignment_id = p_assignment_id

Line 418: INDEX(PAF PER_ASSIGNMENTS_F_PK)

414: )
415: UNION
416: SELECT /*+ ORDERED INDEX(PDE PAY_DATETRACKED_EVENTS_UK1)
417: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
418: INDEX(PAF PER_ASSIGNMENTS_F_PK)
419: USE_NL(PDE PAF)*/
420: DISTINCT
421: pee.element_entry_id entry,
422: pde.datetracked_event_id

Line 1419: per_assignments_f asg,

1415: hr_utility.trace('In range_cursor');
1416: /* Effective date will be set to sysdate for CC*/
1417: sqlstr := 'select distinct asg.person_id
1418: from
1419: per_assignments_f asg,
1420: pay_payroll_actions pa1
1421: where pa1.payroll_action_id = :payroll_action_id
1422: and asg.payroll_id =
1423: pay_core_utils.get_parameter(''PAYROLL_ID'',

Line 1473: per_assignments_f paf,

1469: USE_NL(pos paf) */
1470: paf.assignment_id
1471: from
1472: per_periods_of_service pos,
1473: per_assignments_f paf,
1474: pay_payroll_actions ppa
1475: where ppa.payroll_action_id = pactid
1476: and paf.payroll_id =
1477: pay_core_utils.get_parameter('PAYROLL_ID',

Line 1504: per_assignments_f paf,

1500: USE_NL(pos paf) */
1501: paf.assignment_id
1502: FROM pay_population_ranges ppr,
1503: per_periods_of_service pos,
1504: per_assignments_f paf,
1505: pay_payroll_actions ppa
1506: where ppa.payroll_action_id = pactid
1507: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1508: and pos.period_of_service_id = paf.period_of_service_id