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 1484: per_assignments_f asg,

1480: hr_utility.trace('In range_cursor');
1481: /* Effective date will be set to sysdate for CC*/
1482: sqlstr := 'select distinct asg.person_id
1483: from
1484: per_assignments_f asg,
1485: pay_payroll_actions pa1
1486: where pa1.payroll_action_id = :payroll_action_id
1487: and asg.payroll_id =
1488: pay_core_utils.get_parameter(''PAYROLL_ID'',

Line 1538: per_assignments_f paf,

1534: USE_NL(pos paf) */
1535: paf.assignment_id
1536: from
1537: per_periods_of_service pos,
1538: per_assignments_f paf,
1539: pay_payroll_actions ppa
1540: where ppa.payroll_action_id = pactid
1541: and paf.payroll_id =
1542: pay_core_utils.get_parameter('PAYROLL_ID',

Line 1569: per_assignments_f paf,

1565: USE_NL(pos paf) */
1566: paf.assignment_id
1567: FROM pay_population_ranges ppr,
1568: per_periods_of_service pos,
1569: per_assignments_f paf,
1570: pay_payroll_actions ppa
1571: where ppa.payroll_action_id = pactid
1572: and paf.payroll_id = pay_core_utils.get_parameter('PAYROLL_ID', ppa.legislative_parameters)
1573: and pos.period_of_service_id = paf.period_of_service_id