eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_PAYROLL_ACTIONS

Line 62: Check on pay_payroll_actions table used in exists

58: to add the missing assignment_id and tax_unit_id
59: check inside the exists clause
60: 08-DEC-2010 emunisek 115.13 10381064 Modified cursors get_latest_rl2_amend_dtls,
61: get_reprint_rl2_amend_dtls to introduce the Date
62: Check on pay_payroll_actions table used in exists
63: clauses
64: 06-SEP-2011 rgottipa 115.14 10399514 introduced new cursores
65: c_selected_asg_set_range and
66: c_all_asg_range. These will be

Line 115: from pay_payroll_actions ppa

111: effective_date,
112: start_date,
113: business_group_id,
114: report_type
115: from pay_payroll_actions ppa
116: where ppa.payroll_action_id = cp_payroll_action_id;
117:
118: ld_end_date DATE;
119: ld_start_date DATE;

Line 197: from pay_payroll_actions ppa

193: report_qualifier,
194: report_category,
195: pay_ca_eoy_rl2_amend_reg.get_parameter(
196: 'PRINT_TERM',ppa.legislative_parameters)
197: from pay_payroll_actions ppa
198: where ppa.payroll_action_id = cp_payroll_action_id;
199:
200: ld_end_date DATE;
201: ld_start_date DATE;

Line 329: from pay_payroll_actions ppa_arch,

325: elsif ln_pre_org_id is not NULL then
326:
327: lv_sql_string :=
328: 'select distinct paf.person_id
329: from pay_payroll_actions ppa_arch,
330: pay_assignment_actions paa_arch,
331: per_assignments_f paf,
332: pay_payroll_actions ppa
333: where paa_arch.assignment_id = paf.assignment_id

Line 332: pay_payroll_actions ppa

328: 'select distinct paf.person_id
329: from pay_payroll_actions ppa_arch,
330: pay_assignment_actions paa_arch,
331: per_assignments_f paf,
332: pay_payroll_actions ppa
333: where paa_arch.assignment_id = paf.assignment_id
334: and ppa.payroll_action_id = :payroll_action_id
335: and ppa_arch.business_group_id = ppa.business_group_id
336: and ppa_arch.effective_date = ppa.effective_date

Line 348: from pay_payroll_actions ppa_arch,

344: else
345:
346: lv_sql_string :=
347: 'select distinct paf.person_id
348: from pay_payroll_actions ppa_arch,
349: pay_assignment_actions paa_arch,
350: per_assignments_f paf,
351: pay_payroll_actions ppa
352: where paa_arch.assignment_id = paf.assignment_id

Line 351: pay_payroll_actions ppa

347: 'select distinct paf.person_id
348: from pay_payroll_actions ppa_arch,
349: pay_assignment_actions paa_arch,
350: per_assignments_f paf,
351: pay_payroll_actions ppa
352: where paa_arch.assignment_id = paf.assignment_id
353: and ppa.payroll_action_id = :payroll_action_id
354: and ppa_arch.business_group_id = ppa.business_group_id
355: and ppa_arch.effective_date = ppa.effective_date

Line 404: lv_report_type pay_payroll_actions.report_type%TYPE ;

400: ln_set_person_id NUMBER := 0 ;
401: ln_asg_set NUMBER := 0 ;
402: lv_print varchar2(10);
403:
404: lv_report_type pay_payroll_actions.report_type%TYPE ;
405: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
406:
407: lv_serial_number VARCHAR2(30);
408: lv_employee_number per_people_f.employee_number%type;

Line 417: l_report_cat pay_payroll_actions.report_category%type;

413: lv_ppr_report_type varchar2(50);
414:
415: -- Variables declared for bug 10399514
416: l_person_on boolean ;
417: l_report_cat pay_payroll_actions.report_category%type;
418: l_state pay_payroll_actions.report_qualifier%type;
419: l_report_format pay_report_format_mappings_f.report_format%type;
420: -- Variables declared for bug 10399514
421: l_print_term varchar2(1);

Line 418: l_state pay_payroll_actions.report_qualifier%type;

414:
415: -- Variables declared for bug 10399514
416: l_person_on boolean ;
417: l_report_cat pay_payroll_actions.report_category%type;
418: l_state pay_payroll_actions.report_qualifier%type;
419: l_report_format pay_report_format_mappings_f.report_format%type;
420: -- Variables declared for bug 10399514
421: l_print_term varchar2(1);
422:

Line 430: pay_payroll_actions ppa_arch,

426: ,cp_effective_date in date) is
427: select distinct paf.person_id
428: from hr_assignment_set_amendments asgset,
429: per_assignments_f paf,
430: pay_payroll_actions ppa_arch,
431: pay_assignment_actions paa_arch
432: where asgset.assignment_set_id = cp_asg_set
433: and asgset.include_or_exclude = 'I'
434: and paf.assignment_id = asgset.assignment_id

Line 457: pay_payroll_actions ppa_arch,

453: ,cp_effective_date in date) is
454: select distinct paf.person_id
455: from hr_assignment_set_amendments asgset,
456: per_assignments_f paf,
457: pay_payroll_actions ppa_arch,
458: pay_assignment_actions paa_arch,
459: pay_population_ranges ppr
460: where asgset.assignment_set_id = cp_asg_set
461: and asgset.include_or_exclude = 'I'

Line 494: FROM pay_payroll_actions ppa ,

490: fnd_date.canonical_to_date('4712/12/31 00:00:00')) >= cp_eff_date
491: AND hoi.org_information_context = 'Prov Reporting Est'
492: AND hoi.org_information4 = 'P02'
493: AND exists ( SELECT 1
494: FROM pay_payroll_actions ppa ,
495: pay_assignment_actions paa
496: WHERE ppa.report_type = 'CAEOY_RL2_AMEND_PP'
497: AND ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'
498: AND ppa.business_group_id = cp_bg_id

Line 510: from pay_payroll_actions ppa_arch,

506: cp_eff_date date,
507: cp_start_person number,
508: cp_end_person number) is
509: select distinct paa_arch.serial_number
510: from pay_payroll_actions ppa_arch,
511: pay_assignment_actions paa_arch
512: where ppa_arch.business_group_id = cp_bg_id
513: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
514: AND ppa_arch.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'

Line 532: from pay_payroll_actions ppa_arch,

528: cp_eff_date date,
529: cp_start_person number,
530: cp_end_person number) is
531: select distinct paa_arch.serial_number
532: from pay_payroll_actions ppa_arch,
533: pay_assignment_actions paa_arch,
534: pay_population_ranges ppr
535: where ppa_arch.business_group_id = cp_bg_id
536: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'

Line 563: from pay_payroll_actions ppa,

559: paa.assignment_action_id,
560: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
561: ppa.legislative_parameters),
562: paf.effective_end_date
563: from pay_payroll_actions ppa,
564: pay_assignment_actions paa,
565: per_assignments_f paf
566: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
567: and paa.assignment_id = paf.assignment_id

Line 585: pay_payroll_actions pact,

581: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
582: AND not exists
583: ( SELECT pail.locked_action_id
584: FROM pay_action_interlocks pail,
585: pay_payroll_actions pact,
586: pay_assignment_actions passt
587: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND'),'CAEOY_RL2_AMEND_PP')/*Added for Bug#5046010*/
588: AND pact.payroll_action_id = passt.payroll_action_id
589: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 611: from pay_payroll_actions ppa,

607: paa.assignment_id,
608: paa.assignment_action_id,
609: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
610: ppa.legislative_parameters)
611: from pay_payroll_actions ppa,
612: pay_assignment_actions paa
613: where paa.serial_number = to_char(cp_person_id)
614: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
615: ppa.legislative_parameters) =

Line 643: from pay_payroll_actions ppa,

639: paa.assignment_action_id,
640: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
641: ppa.legislative_parameters),
642: paf.effective_end_date
643: from pay_payroll_actions ppa,
644: pay_assignment_actions paa,
645: per_assignments_f paf
646: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
647: and paa.assignment_id = paf.assignment_id

Line 665: pay_payroll_actions pact,

661: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
662: and exists
663: ( SELECT pail.locked_action_id
664: FROM pay_action_interlocks pail,
665: pay_payroll_actions pact,
666: pay_assignment_actions passt
667: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND')
668: AND pact.payroll_action_id = passt.payroll_action_id
669: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 678: FROM pay_payroll_actions ppa2,

674: AND (pail.locked_action_id = paa.assignment_action_id
675: OR paa.assignment_action_id < passt.assignment_action_id))
676: and ((not exists
677: ( SELECT 1
678: FROM pay_payroll_actions ppa2,
679: pay_assignment_actions paa2
680: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
681: AND ppa2.payroll_action_id = paa2.payroll_action_id
682: AND paa2.assignment_action_id > paa.assignment_action_id

Line 706: from pay_payroll_actions ppa,

702: paa.assignment_action_id,
703: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
704: ppa.legislative_parameters),
705: paf.effective_end_date
706: from pay_payroll_actions ppa,
707: pay_assignment_actions paa,
708: per_assignments_f paf,
709: per_periods_of_service pds
710: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)

Line 729: pay_payroll_actions pact,

725: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
726: AND not exists
727: ( SELECT pail.locked_action_id
728: FROM pay_action_interlocks pail,
729: pay_payroll_actions pact,
730: pay_assignment_actions passt
731: WHERE pact.report_type in (decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND'),'CAEOY_RL2_AMEND_PP')/*Added for Bug#5046010*/
732: AND pact.payroll_action_id = passt.payroll_action_id
733: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 758: from pay_payroll_actions ppa,

754: paa.assignment_action_id,
755: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
756: ppa.legislative_parameters),
757: paf.effective_end_date
758: from pay_payroll_actions ppa,
759: pay_assignment_actions paa,
760: per_assignments_f paf,
761: per_periods_of_service pds
762: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)

Line 781: pay_payroll_actions pact,

777: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
778: and exists
779: ( SELECT pail.locked_action_id
780: FROM pay_action_interlocks pail,
781: pay_payroll_actions pact,
782: pay_assignment_actions passt
783: WHERE pact.report_type = decode(lv_ppr_report_type,'PAYCARL2AMPDF','PAYCARL2AMPDF','PYRL2PRAMEND')
784: AND pact.payroll_action_id = passt.payroll_action_id
785: AND pact.effective_date = cp_effective_date /*Added for 10381064*/

Line 794: FROM pay_payroll_actions ppa2,

790: AND (pail.locked_action_id = paa.assignment_action_id
791: OR paa.assignment_action_id < passt.assignment_action_id))
792: and ((not exists
793: ( SELECT 1
794: FROM pay_payroll_actions ppa2,
795: pay_assignment_actions paa2
796: WHERE ppa2.report_type = 'CAEOY_RL2_AMEND_PP'
797: AND ppa2.payroll_action_id = paa2.payroll_action_id
798: AND paa2.assignment_action_id > paa.assignment_action_id

Line 818: from pay_payroll_actions

814: CURSOR get_yepp_pact_id(cp_bg_id number,
815: cp_pre number,
816: cp_year date) IS
817: select payroll_action_id
818: from pay_payroll_actions
819: where business_group_id = cp_bg_id
820: and report_type = 'RL2'
821: and report_qualifier = 'CAEOYRL2'
822: and action_type = 'X'

Line 1616: pay_payroll_actions ppa1

1612: hr_locations_all loc,
1613: per_all_people_f ppf,
1614: per_all_assignments_f paf,
1615: pay_assignment_actions paa1,
1616: pay_payroll_actions ppa1
1617: where ppa1.payroll_action_id = :pactid
1618: and paa1.payroll_action_id = ppa1.payroll_action_id
1619: and paa1.assignment_id = paf.assignment_id
1620: and paf.business_group_id = ppa1.business_group_id

Line 1660: token_val pay_payroll_actions.legislative_parameters%type;

1656: parameter_list varchar2) return varchar2
1657: IS
1658: start_ptr number;
1659: end_ptr number;
1660: token_val pay_payroll_actions.legislative_parameters%type;
1661: par_value pay_payroll_actions.legislative_parameters%type;
1662:
1663: BEGIN
1664:

Line 1661: par_value pay_payroll_actions.legislative_parameters%type;

1657: IS
1658: start_ptr number;
1659: end_ptr number;
1660: token_val pay_payroll_actions.legislative_parameters%type;
1661: par_value pay_payroll_actions.legislative_parameters%type;
1662:
1663: BEGIN
1664:
1665: token_val := name||'=';