APPS.PAY_IE_P45PART3_P46_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 112: FROM pay_payroll_actions

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

Line 224: FROM pay_payroll_actions

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

Line 269: ' pay_payroll_actions pa' ||

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

Line 408: pay_payroll_actions ppa,

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

Line 488: pay_payroll_actions ppa,

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

Line 510: pay_payroll_actions ppa,

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

Line 687: FROM pay_payroll_actions

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