APPS.PER_IE_ORG_INFO dependencies on HR_SOFT_CODING_KEYFLEX

Line 287: hr_soft_coding_keyflex scl

283: from dual
284: where exists(select NULL
285: from per_all_assignments_f paa,
286: pay_all_payrolls_f pap,
287: hr_soft_coding_keyflex scl
288: where paa.payroll_id = pap.payroll_id
289: and p_effective_date not between paa.effective_start_date and paa.effective_end_date
290: and paa.assignment_id = p_assignment_id
291: and pap.payroll_id <> p_payroll_id

Line 302: from hr_soft_coding_keyflex sck

298: cursor csr_get_paye_ref(p_payroll_id number,
299: p_business_group_id number,
300: p_effective_date date) is
301: select sck.segment4
302: from hr_soft_coding_keyflex sck
303: ,pay_all_payrolls_f pay
304: where pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
305: and pay.payroll_id = p_payroll_id
306: and P_EFFECTIVE_DATE between pay.effective_start_date and pay.effective_end_date

Line 309: l_old_paye_ref hr_soft_coding_keyflex.segment4%TYPE;

305: and pay.payroll_id = p_payroll_id
306: and P_EFFECTIVE_DATE between pay.effective_start_date and pay.effective_end_date
307: and pay.business_group_id=p_business_group_id;
308:
309: l_old_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;

Line 310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;

306: and P_EFFECTIVE_DATE between pay.effective_start_date and pay.effective_end_date
307: and pay.business_group_id=p_business_group_id;
308:
309: l_old_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
310: l_new_paye_ref hr_soft_coding_keyflex.segment4%TYPE;
311: l_prim_payroll_id per_all_assignments_f.payroll_id%TYPE;
312: l_new_payroll_id per_all_assignments_f.payroll_id%TYPE;
313: l_person_id per_all_people_f.person_id%type;
314: l_assignment_id per_all_assignments_f.assignment_id%type;