APPS.PAY_GB_ROLLBACK dependencies on PAY_PAYROLL_ACTIONS

Line 112: FROM pay_payroll_actions

108:
109: CURSOR csr_report_type
110: IS
111: SELECT report_type
112: FROM pay_payroll_actions
113: WHERE payroll_action_id = p_pactid;
114:
115: l_asgact_rec csr_archive_asgact_details%rowtype;
116: l_report_type varchar2(50);

Line 238: pay_payroll_actions ppa,

234: CURSOR csr_asgs_processed
235: IS
236: SELECT DISTINCT paa.assignment_id
237: FROM pay_assignment_actions paa,
238: pay_payroll_actions ppa,
239: pay_action_information pai
240: WHERE paa.payroll_action_id = ppa.payroll_action_id
241: AND ppa.payroll_action_id = p_pactid --1688760
242: AND paa.assignment_action_id = pai.action_context_id;

Line 248: pay_payroll_actions ppa,

244: CURSOR csr_asgs_asgact_processed
245: IS
246: SELECT DISTINCT paa.assignment_id
247: FROM pay_assignment_actions paa,
248: pay_payroll_actions ppa,
249: pay_action_information pai
250: WHERE paa.payroll_action_id = ppa.payroll_action_id
251: AND ppa.payroll_action_id = p_pactid --1688760
252: AND paa.assignment_action_id = pai.action_context_id

Line 258: from pay_payroll_actions

254:
255: cursor csr_fetch_details is
256: select fnd_date.canonical_to_date(substr(legislative_parameters,instr(legislative_parameters,'START=') + 6,10)) effective_date,
257: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
258: from pay_payroll_actions
259: where payroll_action_id = p_pactid;
260:
261: cursor csr_fetch_agg(p_asg_id number)
262: is

Line 381: pay_payroll_actions ppa

377: CURSOR csr_asgs_processed
378: IS
379: SELECT DISTINCT paa.assignment_id
380: FROM pay_assignment_actions paa,
381: pay_payroll_actions ppa
382: WHERE paa.payroll_action_id = ppa.payroll_action_id
383: AND ppa.payroll_action_id = p_pactid; --1688760
384:
385: CURSOR csr_asgs_asgact_processed

Line 389: pay_payroll_actions ppa

385: CURSOR csr_asgs_asgact_processed
386: IS
387: SELECT DISTINCT paa.assignment_id
388: FROM pay_assignment_actions paa,
389: pay_payroll_actions ppa
390: WHERE paa.payroll_action_id = ppa.payroll_action_id
391: AND ppa.payroll_action_id = p_pactid
392: and paa.assignment_action_id = p_asgactid ;
393:

Line 397: from pay_payroll_actions prev,

393:
394: cursor is_prev_flag(p_asg_id number)
395: is
396: select 'Y' from dual where exists(select *
397: from pay_payroll_actions prev,
398: pay_assignment_actions paa
399: where paa.assignment_id = p_asg_id
400: and paa.payroll_action_id = prev.payroll_action_id
401: and prev.payroll_action_id <> p_pactid

Line 457: FROM pay_payroll_actions

453:
454: CURSOR csr_report_type
455: IS
456: SELECT report_type
457: FROM pay_payroll_actions
458: WHERE payroll_action_id = p_pactid;
459:
460: l_report_type varchar2(50);
461:

Line 506: FROM pay_payroll_actions

502:
503: CURSOR csr_report_type
504: IS
505: SELECT report_type
506: FROM pay_payroll_actions
507: WHERE payroll_action_id = p_pactid;
508:
509: l_report_type varchar2(50);
510: BEGIN