APPS.PAY_GB_REP dependencies on PER_ALL_ASSIGNMENTS_F

Line 37: per_all_assignments_f paf,

33: paf.assignment_id
34: -- hr_gbbal.calc_all_balances(fnd_date.canonical_to_date(p_effective_date), paf.assignment_id, p_def_bal_id ) ni_arrears
35: from per_all_people_f ppf,
36: per_person_types ppt,
37: per_all_assignments_f paf,
38: pay_all_payrolls_f papf
39: where ppf.business_group_id = p_business_group_id
40: and papf.business_group_id = p_business_group_id
41: and ppt.business_group_id = p_business_group_id

Line 137: per_all_assignments_f paf,

133: select paf.assignment_number,
134: ppf.full_name,
135: paf.assignment_id
136: from per_all_people_f ppf,
137: per_all_assignments_f paf,
138: per_assignment_status_types past
139: where paf.assignment_status_type_id = past.assignment_status_type_id
140: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
141: and ppf.business_group_id = c_business_group_id

Line 151: from per_all_assignments_f

147: lpad(nvl(substr(assignment_number,decode(instr(assignment_number,'-'),0,null,instr(assignment_number,'-')+1)),'0'),10,'0');
148:
149: cursor csr_asg_dtls(c_assignment_id number) is
150: select assignment_number
151: from per_all_assignments_f
152: where assignment_id = c_assignment_id;
153:
154: cursor csr_locked_act_dtls(c_asg_action_id NUMBER) IS
155: select locking_action_id, pact.effective_date

Line 169: l_agg_assignment_number per_all_assignments_f.assignment_number%type;

165: l_issue_date date;
166:
167: l_assignment_action_id number;
168: l_agg_assignment_id number;
169: l_agg_assignment_number per_all_assignments_f.assignment_number%type;
170: l_final_payment_date date;
171: l_p45_issue_date date;
172: l_p45_agg_asg_action_id number;
173: l_action_sequence number;