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_T4AEOY_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 303: /* Returns the value of a legislative_parameter from pay_payroll_actions */

299: sqwl_range varchar2(4000);
300: eoy_gre_range varchar2(4000);
301: eoy_all_range varchar2(4000);
302:
303: /* Returns the value of a legislative_parameter from pay_payroll_actions */
304:
305: function get_parameter(name in varchar2,
306: parameter_list varchar2)
307: return varchar2

Line 311: token_val pay_payroll_actions.legislative_parameters%type;

307: return varchar2
308: is
309: start_ptr number;
310: end_ptr number;
311: token_val pay_payroll_actions.legislative_parameters%type;
312: par_value pay_payroll_actions.legislative_parameters%type;
313: begin
314:
315: token_val := name||'=';

Line 312: par_value pay_payroll_actions.legislative_parameters%type;

308: is
309: start_ptr number;
310: end_ptr number;
311: token_val pay_payroll_actions.legislative_parameters%type;
312: par_value pay_payroll_actions.legislative_parameters%type;
313: begin
314:
315: token_val := name||'=';
316:

Line 536: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

532: /* Variables used to hold the details of the payroll and assignment actions
533: that are created. */
534:
535: l_payroll_action_created boolean := false;
536: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
537: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
538:
539: /* Variable holding the balance to be tested. */
540:

Line 567: l_report_type pay_payroll_actions.report_type%type;

563: l_jurisdiction_code varchar2(30);
564:
565: /* general process variables */
566:
567: l_report_type pay_payroll_actions.report_type%type;
568: -- Variables declared for bug 10399514
569: l_person_on boolean ;
570: l_report_cat pay_payroll_actions.report_category%type;
571: l_state pay_payroll_actions.report_qualifier%type;

Line 570: l_report_cat pay_payroll_actions.report_category%type;

566:
567: l_report_type pay_payroll_actions.report_type%type;
568: -- Variables declared for bug 10399514
569: l_person_on boolean ;
570: l_report_cat pay_payroll_actions.report_category%type;
571: l_state pay_payroll_actions.report_qualifier%type;
572: l_report_format pay_report_format_mappings_f.report_format%type;
573: -- Variables declared for bug 10399514
574: l_province pay_payroll_actions.report_qualifier%type;

Line 571: l_state pay_payroll_actions.report_qualifier%type;

567: l_report_type pay_payroll_actions.report_type%type;
568: -- Variables declared for bug 10399514
569: l_person_on boolean ;
570: l_report_cat pay_payroll_actions.report_category%type;
571: l_state pay_payroll_actions.report_qualifier%type;
572: l_report_format pay_report_format_mappings_f.report_format%type;
573: -- Variables declared for bug 10399514
574: l_province pay_payroll_actions.report_qualifier%type;
575: l_value number;

Line 574: l_province pay_payroll_actions.report_qualifier%type;

570: l_report_cat pay_payroll_actions.report_category%type;
571: l_state pay_payroll_actions.report_qualifier%type;
572: l_report_format pay_report_format_mappings_f.report_format%type;
573: -- Variables declared for bug 10399514
574: l_province pay_payroll_actions.report_qualifier%type;
575: l_value number;
576: old_l_value number;
577: l_registration_no varchar2(150);
578: l_balance_name varchar2(150);

Line 600: pay_payroll_actions ppa

596: paa.tax_unit_id tax_unit_id,
597: ASG.effective_end_date effective_end_date
598: FROM per_all_assignments_f ASG,
599: pay_assignment_actions paa,
600: pay_payroll_actions ppa
601: WHERE ppa.payroll_action_id >= 0
602: AND ppa.effective_date between l_period_start
603: and l_period_end
604: AND ppa.action_type in ('R','Q','V','B','I')

Line 625: pay_payroll_actions ppa,

621: paa.tax_unit_id tax_unit_id,
622: ASG.effective_end_date effective_end_date
623: FROM per_all_assignments_f ASG,
624: pay_assignment_actions paa,
625: pay_payroll_actions ppa,
626: per_all_people_f ppf
627: WHERE ppa.effective_date between l_period_start
628: and l_period_end
629: AND ppa.action_type in ('R','Q','V','B','I')

Line 654: pay_payroll_actions ppa,

650: paa.tax_unit_id tax_unit_id,
651: ASG.effective_end_date effective_end_date
652: FROM per_all_assignments_f ASG,
653: pay_assignment_actions paa,
654: pay_payroll_actions ppa,
655: per_all_people_f ppf,
656: pay_population_ranges ppr
657: WHERE ppa.effective_date between l_period_start
658: and l_period_end

Line 733: from pay_payroll_actions

729: l_report_cat,
730: -- Added for bug 10399514
731: l_bus_group_id,
732: l_legislative_parameters
733: from pay_payroll_actions
734: where payroll_action_id = pactid;
735:
736: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
737:

Line 886: pay_payroll_actions ppa2,

882: select paa1.assignment_action_id
883: into l_max_aaid
884: from pay_assignment_actions paa1,
885: per_all_assignments_f paf2,
886: pay_payroll_actions ppa2,
887: pay_action_classifications pac2
888: where paf2.person_id = l_person_id
889: and paa1.assignment_id = paf2.assignment_id
890: and paa1.tax_unit_id = l_tax_unit_id

Line 900: pay_payroll_actions ppa,

896: and ppa2.effective_date between l_period_start and
897: l_period_end
898: and not exists (select ''
899: FROM pay_action_classifications pac,
900: pay_payroll_actions ppa,
901: pay_assignment_actions paa,
902: per_all_assignments_f paf1
903: WHERE paf1.person_id = l_person_id
904: AND paa.assignment_id = paf1.assignment_id

Line 1596: from pay_payroll_actions

1592: select to_char(effective_date,'YYYY'),
1593: add_months(trunc(effective_date, 'Y'),12) - 1
1594: into l_taxation_year,
1595: l_effective_date
1596: from pay_payroll_actions
1597: where payroll_action_id = p_payroll_action_id;
1598:
1599: exception when no_data_found then
1600: l_taxation_year := null;

Line 2029: , pay_payroll_actions run_ppa

2025: , pay_element_types_f pet
2026: , pay_input_values_f piv1
2027: , pay_input_values_f piv2
2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf

Line 2031: , pay_payroll_actions arch_ppa

2027: , pay_input_values_f piv2
2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
2030: , pay_assignment_actions arch_paa
2031: , pay_payroll_actions arch_ppa
2032: , per_all_assignments_f arch_paf
2033: , per_all_assignments_f all_paf
2034: , hr_all_organization_units hou
2035: , hr_organization_information hoi

Line 2095: pay_payroll_actions ppa,

2091: CURSOR c_get_latest_asg(p_person_id number ) IS
2092: select paa.assignment_action_id
2093: from pay_assignment_actions paa,
2094: per_all_assignments_f paf,
2095: pay_payroll_actions ppa,
2096: pay_action_classifications pac
2097: where paf.person_id = p_person_id
2098: and paa.assignment_id = paf.assignment_id
2099: and paa.tax_unit_id = l_tax_unit_id

Line 2121: from pay_payroll_actions ppa,pay_assignment_actions paa

2117: /* New cursors added for Federal YE Amendment Pre-Process Validation */
2118:
2119: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
2120: select ppa.report_type
2121: from pay_payroll_actions ppa,pay_assignment_actions paa
2122: where paa.assignment_action_id = cp_locked_actid
2123: and ppa.payroll_action_id = paa.payroll_action_id;
2124:
2125: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 3442: , pay_payroll_actions run_ppa

3438: , pay_element_types_f pet
3439: , pay_input_values_f piv1
3440: , pay_input_values_f piv2
3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf

Line 3444: , pay_payroll_actions arch_ppa

3440: , pay_input_values_f piv2
3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa
3443: , pay_assignment_actions arch_paa
3444: , pay_payroll_actions arch_ppa
3445: , per_all_assignments_f arch_paf
3446: , per_all_assignments_f all_paf
3447: , hr_all_organization_units hou
3448: , hr_organization_information hoi

Line 3509: pay_payroll_actions ppa,

3505: CURSOR c_get_latest_asg(p_person_id number ) IS
3506: select paa.assignment_action_id
3507: from pay_assignment_actions paa,
3508: per_all_assignments_f paf,
3509: pay_payroll_actions ppa,
3510: pay_action_classifications pac
3511: where paf.person_id = p_person_id
3512: and paa.assignment_id = paf.assignment_id
3513: and paa.tax_unit_id = l_tax_unit_id

Line 3535: from pay_payroll_actions ppa,pay_assignment_actions paa

3531: /* New cursors added for Federal YE Amendment Pre-Process Validation */
3532:
3533: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
3534: select ppa.report_type
3535: from pay_payroll_actions ppa,pay_assignment_actions paa
3536: where paa.assignment_action_id = cp_locked_actid
3537: and ppa.payroll_action_id = paa.payroll_action_id;
3538:
3539: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 3636: pay_payroll_actions ppa,

3632: and paa1.tax_unit_id = l_tax_unit_id
3633: and (paa1.action_sequence , paf2.person_id) =
3634: (SELECT MAX(paa.action_sequence), paf.person_id
3635: FROM pay_action_classifications pac,
3636: pay_payroll_actions ppa,
3637: pay_assignment_actions paa,
3638: per_all_assignments_f paf1,
3639: per_all_assignments_f paf
3640: WHERE paf.assignment_id = l_asgid

Line 3721: from pay_payroll_actions

3717: select effective_date,
3718: report_type
3719: into ld_fapp_effective_date,
3720: lv_fapp_report_type
3721: from pay_payroll_actions
3722: where payroll_action_id = l_payroll_action_id;
3723: EXCEPTION
3724: WHEN OTHERS THEN
3725: lv_fapp_report_type :='T4A';

Line 5327: from pay_payroll_actions

5323: select effective_date,
5324: report_type
5325: into ld_fapp_effective_date,
5326: lv_fapp_report_type
5327: from pay_payroll_actions
5328: where payroll_action_id = l_payroll_action_id;
5329: */
5330:
5331:

Line 5465: from pay_payroll_actions

5461: into l_legislative_parameters,
5462: l_year_start,
5463: l_year_end,
5464: l_business_group
5465: from pay_payroll_actions
5466: where payroll_action_id = pactid;
5467:
5468: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
5469:

Line 5485: PPA PAY_PAYROLL_ACTIONS_N51,

5481:
5482: if l_eoy_tax_unit_id <> -99999 then
5483:
5484: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
5485: PPA PAY_PAYROLL_ACTIONS_N51,
5486: PAA PAY_ASSIGNMENT_ACTIONS_N50,
5487: ASG PER_ASSIGNMENTS_F_PK,
5488: PPA1 PAY_PAYROLL_ACTIONS_PK)
5489: USE_NL(PPY, PPA, PAA, ASG, PPA1) */

Line 5488: PPA1 PAY_PAYROLL_ACTIONS_PK)

5484: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
5485: PPA PAY_PAYROLL_ACTIONS_N51,
5486: PAA PAY_ASSIGNMENT_ACTIONS_N50,
5487: ASG PER_ASSIGNMENTS_F_PK,
5488: PPA1 PAY_PAYROLL_ACTIONS_PK)
5489: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
5490: distinct asg.person_id
5491: from pay_all_payrolls_f ppy,
5492: pay_payroll_actions ppa,

Line 5492: pay_payroll_actions ppa,

5488: PPA1 PAY_PAYROLL_ACTIONS_PK)
5489: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
5490: distinct asg.person_id
5491: from pay_all_payrolls_f ppy,
5492: pay_payroll_actions ppa,
5493: pay_assignment_actions paa,
5494: per_all_assignments_f asg,
5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id

Line 5495: pay_payroll_actions ppa1

5491: from pay_all_payrolls_f ppy,
5492: pay_payroll_actions ppa,
5493: pay_assignment_actions paa,
5494: per_all_assignments_f asg,
5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||
5499: fnd_date.date_to_canonical(l_year_start)||''') and