APPS.PAY_IE_P45PART3_P46_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 115: FROM pay_payroll_actions

111: ) + LENGTH(p_token)
112: )
113: )),
114: TRIM(business_group_id)
115: FROM pay_payroll_actions
116: WHERE payroll_action_id = p_pact_id;
117:
118: l_business_group_id VARCHAR2(300);
119: l_token_value VARCHAR2(300);

Line 227: FROM pay_payroll_actions

223: l_end_date VARCHAR2(50);
224:
225: CURSOR csr_archive_effective_date(pactid NUMBER) IS
226: SELECT effective_date
227: FROM pay_payroll_actions
228: WHERE payroll_action_id = pactid;
229:
230: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
231: ,c_bg_id hr_organization_units.business_group_id%type) IS

Line 272: ' pay_payroll_actions pa' ||

268: hr_utility.set_location('pactid '||TO_CHAR(pactid), 200);
269:
270: sqlstr := ' select distinct p.person_id' ||
271: ' from per_people_f p,' ||
272: ' pay_payroll_actions pa' ||
273: ' where pa.payroll_action_id = :payroll_action_id' ||
274: ' and p.business_group_id = pa.business_group_id' ||
275: ' order by p.person_id';
276:

Line 411: pay_payroll_actions ppa,

407: CURSOR csr_already_archived (p_assg_id number, p_bg_id in number)
408: IS
409: select 'Y'
410: FROM
411: pay_payroll_actions ppa,
412: pay_assignment_actions paa,
413: PAY_ACTION_INFORMATION pai
414: WHERE
415: paa.payroll_action_id = ppa.payroll_action_id

Line 491: pay_payroll_actions ppa,

487: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from
488: per_all_assignments_f paaf,
489: per_all_people_f ppf,
490: pay_all_payrolls_f papf,
491: pay_payroll_actions ppa,
492: hr_soft_coding_keyflex scl
493: where paaf.business_group_id = '|| g_business_group_id
494: ||' and paaf.effective_start_date between '||''''||g_start_date||''''||' and '
495: ||''''||g_end_date||''''

Line 513: pay_payroll_actions ppa,

509: from
510: per_all_assignments_f paaf,
511: per_all_people_f ppf,
512: pay_all_payrolls_f papf,
513: pay_payroll_actions ppa,
514: hr_soft_coding_keyflex scl,
515: per_periods_of_service pps
516: where paaf.business_group_id = '|| g_business_group_id
517: ||' and paaf.effective_start_date between '||''''||g_start_date||''''||' and '

Line 690: FROM pay_payroll_actions

686:
687:
688: CURSOR csr_archive_effective_date(pactid NUMBER) IS
689: SELECT effective_date
690: FROM pay_payroll_actions
691: WHERE payroll_action_id = pactid;
692:
693: /*
694: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type