APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PER_ASSIGNMENTS_F

Line 164: from per_assignments_f a,

160: c_end_person_id in per_all_people_f.person_id%type) is
161: select distinct a.assignment_id,
162: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
163: ppac.assignment_action_id
164: from per_assignments_f a,
165: per_people_f p,
166: pay_payroll_actions pa,
167: pay_payroll_actions ppa,
168: pay_assignment_actions ppac

Line 220: per_assignments_f a,

216: FROM pay_payroll_actions pa,
217: pay_population_ranges ppr,
218: pay_payroll_actions ppa,
219: per_people_f p,
220: per_assignments_f a,
221: pay_assignment_actions ppac
222: WHERE pa.payroll_action_id = c_payroll_action_id
223: AND ppr.payroll_action_id = pa.payroll_action_id
224: AND ppr.chunk_number = c_chunk

Line 291: FROM per_assignments_f a

287: SELECT DISTINCT a.assignment_id
288: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
289: ,ppac.assignment_action_id
290: ,pmaa.assignment_action_id datafile_action_id
291: FROM per_assignments_f a
292: ,per_people_f p
293: ,pay_payroll_actions pa
294: ,pay_payroll_actions ppa
295: ,pay_assignment_actions ppac

Line 350: FROM per_assignments_f a

346: SELECT DISTINCT a.assignment_id
347: ,pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id
348: ,ppac.assignment_action_id
349: ,pmaa.assignment_action_id datafile_action_id
350: FROM per_assignments_f a
351: ,per_people_f p
352: ,pay_payroll_actions pa
353: ,pay_payroll_actions ppa
354: ,pay_assignment_actions ppac

Line 823: function ss_pref(p_assignemnt_id per_assignments_f.assignment_id%type) return varchar2

819: ---
820: -- Bug 4726357 Added to check whether Self Service Option is enabled for the employee
821: ---
822:
823: function ss_pref(p_assignemnt_id per_assignments_f.assignment_id%type) return varchar2
824: is
825:
826: l_bg_id number;
827: l_loc_id number;

Line 835: from per_assignments_f paf

831:
832: /* Cursor to get the business group id, location id, organization id and person id */
833: cursor asg_info is
834: select paf.business_group_id, paf.location_id, paf.organization_id,paf.person_id
835: from per_assignments_f paf
836: where paf.assignment_id = p_assignemnt_id
837: and paf.effective_start_date =
838: (select max(effective_start_date)
839: from per_assignments_f paf2

Line 839: from per_assignments_f paf2

835: from per_assignments_f paf
836: where paf.assignment_id = p_assignemnt_id
837: and paf.effective_start_date =
838: (select max(effective_start_date)
839: from per_assignments_f paf2
840: where paf2.assignment_id = paf.assignment_id
841: );
842:
843: /* Cursor to get the option sets at different level i.e Person level, Location Level, Organization Level and