APPS.PAY_GB_ROLLBACK_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 60: FROM pay_payroll_actions

56:
57: CURSOR csr_report_type
58: IS
59: SELECT report_type
60: FROM pay_payroll_actions
61: WHERE payroll_action_id = p_pactid;
62:
63: BEGIN
64: hr_utility.set_location('Entering: '||l_proc,1);

Line 138: FROM pay_payroll_actions

134:
135: CURSOR csr_report_type
136: IS
137: SELECT report_type
138: FROM pay_payroll_actions
139: WHERE payroll_action_id = p_pactid;
140:
141: l_asgact_rec csr_archive_asgact_details%rowtype;
142: l_report_type varchar2(50);

Line 301: FROM pay_payroll_actions

297:
298: CURSOR csr_report_type
299: IS
300: SELECT report_type
301: FROM pay_payroll_actions
302: WHERE payroll_action_id = p_pactid;
303:
304: l_asgact_rec csr_archive_asgact_details%rowtype;
305: l_report_type varchar2(50);

Line 401: pay_payroll_actions ppa,

397: CURSOR csr_asgs_processed
398: IS
399: SELECT DISTINCT paa.assignment_id
400: FROM pay_assignment_actions paa,
401: pay_payroll_actions ppa,
402: pay_action_information pai
403: WHERE paa.payroll_action_id = ppa.payroll_action_id
404: AND ppa.payroll_action_id = p_pactid --1688760
405: AND paa.assignment_action_id = pai.action_context_id;

Line 410: from pay_payroll_actions

406:
407: cursor csr_fetch_details is
408: select fnd_date.canonical_to_date(substr(legislative_parameters,instr(legislative_parameters,'START=') + 6,10)) effective_date,
409: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref
410: from pay_payroll_actions
411: where payroll_action_id = p_pactid;
412:
413: cursor csr_fetch_agg(p_asg_id number)
414: is

Line 501: pay_payroll_actions ppa

497: CURSOR csr_asgs_processed
498: IS
499: SELECT DISTINCT paa.assignment_id
500: FROM pay_assignment_actions paa,
501: pay_payroll_actions ppa
502: WHERE paa.payroll_action_id = ppa.payroll_action_id
503: AND ppa.payroll_action_id = p_pactid; --1688760
504:
505: cursor is_prev_flag(p_asg_id number)

Line 508: from pay_payroll_actions prev,

504:
505: cursor is_prev_flag(p_asg_id number)
506: is
507: select 'Y' from dual where exists(select *
508: from pay_payroll_actions prev,
509: pay_assignment_actions paa
510: where paa.assignment_id = p_asg_id
511: and paa.payroll_action_id = prev.payroll_action_id
512: and prev.payroll_action_id <> p_pactid