APPS.PAY_US_W2C_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 100: from pay_payroll_actions ppa

96: pay_us_payroll_utils.get_parameter('S3',ppa.legislative_parameters),
97: to_date(pay_us_payroll_utils.get_parameter('EFFECTIVE_DATE',
98: ppa.legislative_parameters)
99: ,'dd-mon-yyyy')
100: from pay_payroll_actions ppa
101: where ppa.payroll_action_id = cp_payroll_action_id;
102:
103: ld_end_date DATE;
104: ld_start_date DATE;

Line 284: pay_payroll_actions ppa

280: ELSE
281: lv_sql_string :=
282: 'select distinct paa.serial_number
283: from pay_assignment_actions paa,
284: pay_payroll_actions ppa
285: where ppa.report_type = ''W2C_PRE_PROCESS''
286: and ppa.effective_date = add_months(''' || ld_start_date || ''',12) -1
287: and ppa.business_group_id+0 = ' || ln_business_group_id ||'
288: and ltrim(rtrim(

Line 347: lv_report_type pay_payroll_actions.report_type%TYPE ;

343: lv_sort2 VARCHAR2(60);
344: lv_sort3 VARCHAR2(60);
345: ld_session_date DATE;
346:
347: lv_report_type pay_payroll_actions.report_type%TYPE ;
348: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
349: ln_second_last_arch_action pay_assignment_actions.assignment_action_id%TYPE;
350: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
351:

Line 358: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

354: lv_employee_number per_all_people_f.employee_number%type;
355: lv_message varchar2(50);
356: lv_full_name per_all_people_f.full_name%type;
357: lv_record_name varchar2(50);
358: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
359: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
360: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
361: ln_serial_number pay_assignment_actions.serial_number%TYPE;
362:

Line 385: pay_payroll_actions ppa,

381: cp_business_group_id in number,
382: cp_tax_unit_id in number) IS
383: select distinct paf.person_id
384: from pay_assignment_actions paa,
385: pay_payroll_actions ppa,
386: per_all_assignments_f paf
387: where ppa.report_type = 'W-2C PAPER'
388: and ppa.report_category = 'REPORT'
389: and ppa.report_qualifier = 'DEFAULT'

Line 414: from pay_payroll_actions ppa,

410: ,cp_effective_date in date
411: ,cp_start_date in date) is
412: select ppa.report_type, paa.assignment_id,
413: paa.assignment_action_id
414: from pay_payroll_actions ppa,
415: pay_assignment_actions paa,
416: per_all_assignments_f paf
417: where paa.assignment_id = paf.assignment_id
418: and paf.person_id = cp_person_id

Line 440: from pay_payroll_actions ppa,

436: ,cp_start_date in date
437: ,cp_business_group_id in number) is
438: select ppa.report_type, paa.assignment_id,
439: paa.assignment_action_id
440: from pay_payroll_actions ppa,
441: pay_assignment_actions paa,
442: per_all_assignments_f paf
443: where paa.assignment_id = paf.assignment_id
444: and paf.person_id = cp_person_id

Line 463: pay_payroll_Actions ppa_paper

459: AND paf1.effective_start_date <= ppa.effective_date)
460: and exists (select 1
461: from pay_action_interlocks pai,
462: pay_assignment_actions paa_paper,
463: pay_payroll_Actions ppa_paper
464: where pai.locked_action_id = paa.assignment_action_id
465: and paa_paper.assignment_Action_id = pai.locking_action_id
466: and ppa_paper.payroll_Action_id = paa_paper.payroll_Action_id
467: and ppa_paper.report_type = 'W-2C PAPER'

Line 478: from pay_payroll_actions ppa,

474: CURSOR get_interlocked_action(cp_w2cpp_action in number)is
475: select ppa.report_type,
476: paa.assignment_action_id,
477: substr(paa.serial_number, 1,15) prev_action_id
478: from pay_payroll_actions ppa,
479: pay_assignment_actions paa,
480: pay_action_interlocks pai
481: where pai.locking_action_id = cp_w2cpp_action
482: and paa.assignment_action_id = pai.locked_action_id