APPS.PAY_ZA_IRP5_ARCHIVE_PKG dependencies on PER_ASSIGNMENTS_F

Line 38: FROM per_assignments_f ASG,

34: begin
35:
36: sql_range :=
37: 'SELECT distinct ASG.person_id
38: FROM per_assignments_f ASG,
39: pay_payrolls_f PPY,
40: pay_payroll_actions PPA
41: WHERE PPA.payroll_action_id = :payroll_action_id
42: AND ASG.business_group_id = PPA.business_group_id

Line 67: -- Note: This cursor does not date effectively join to per_assignments_f.

63: ) is
64:
65: -- This cursor returns all assignments for which processing took place
66: -- in the Tax Year.
67: -- Note: This cursor does not date effectively join to per_assignments_f.
68: -- Duplicate assignments are, however, removed in the cursor loop.
69: /*
70: "The cursor looks for assignments that were processed
71: "on the specific payroll that was given in the TYE Archiver SRS -

Line 90: SELECT /*+ INDEX(asg PER_ASSIGNMENTS_F_N12) */

86: --Modified cursor get_asg to date effectively select assignments as at Tax Year End
87: --and to limit them to where the payroll is equal to the specific payroll that was
88: --given in the TYE Archiver SRS
89: cursor get_asg(p_payroll_id pay_all_payrolls_f.payroll_id%TYPE) is
90: SELECT /*+ INDEX(asg PER_ASSIGNMENTS_F_N12) */
91: /* we used the above hint to always ensure that the use the person_id
92: index on per_assignments_f, otherwise, it is feasible the CBO may decide to
93: choose the N7 (payroll_id) index due to it being a bind */
94: asg.person_id person_id

Line 92: index on per_assignments_f, otherwise, it is feasible the CBO may decide to

88: --given in the TYE Archiver SRS
89: cursor get_asg(p_payroll_id pay_all_payrolls_f.payroll_id%TYPE) is
90: SELECT /*+ INDEX(asg PER_ASSIGNMENTS_F_N12) */
91: /* we used the above hint to always ensure that the use the person_id
92: index on per_assignments_f, otherwise, it is feasible the CBO may decide to
93: choose the N7 (payroll_id) index due to it being a bind */
94: asg.person_id person_id
95: , asg.assignment_id assignment_id
96: FROM

Line 414: per_assignments_f paf

410: ppa.payroll_action_id
411: into asgid, l_payroll_id, l_eff_date, l_pact_id
412: from pay_assignment_actions aa,
413: pay_payroll_actions ppa,
414: per_assignments_f paf
415: where aa.assignment_action_id = p_assactid
416: and aa.assignment_id = paf.assignment_id
417: and ppa.payroll_action_id = aa.payroll_action_id
418: and paf.effective_start_date =

Line 421: from per_assignments_f paf2

417: and ppa.payroll_action_id = aa.payroll_action_id
418: and paf.effective_start_date =
419: (
420: select max(paf2.effective_start_date)
421: from per_assignments_f paf2
422: where paf2.effective_start_date <= ppa.effective_date
423: and paf2.assignment_id = aa.assignment_id
424: );
425: