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 225: /* Returns the value of a legislative_parameter from pay_payroll_actions */

221: sqwl_range varchar2(4000);
222: eoy_gre_range varchar2(4000);
223: eoy_all_range varchar2(4000);
224:
225: /* Returns the value of a legislative_parameter from pay_payroll_actions */
226:
227: function get_parameter(name in varchar2,
228: parameter_list varchar2)
229: return varchar2

Line 233: token_val pay_payroll_actions.legislative_parameters%type;

229: return varchar2
230: is
231: start_ptr number;
232: end_ptr number;
233: token_val pay_payroll_actions.legislative_parameters%type;
234: par_value pay_payroll_actions.legislative_parameters%type;
235: begin
236:
237: token_val := name||'=';

Line 234: par_value pay_payroll_actions.legislative_parameters%type;

230: is
231: start_ptr number;
232: end_ptr number;
233: token_val pay_payroll_actions.legislative_parameters%type;
234: par_value pay_payroll_actions.legislative_parameters%type;
235: begin
236:
237: token_val := name||'=';
238:

Line 458: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

454: /* Variables used to hold the details of the payroll and assignment actions
455: that are created. */
456:
457: l_payroll_action_created boolean := false;
458: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
459: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
460:
461: /* Variable holding the balance to be tested. */
462:

Line 489: l_report_type pay_payroll_actions.report_type%type;

485: l_jurisdiction_code varchar2(30);
486:
487: /* general process variables */
488:
489: l_report_type pay_payroll_actions.report_type%type;
490: l_province pay_payroll_actions.report_qualifier%type;
491: l_value number;
492: old_l_value number;
493: l_registration_no varchar2(150);

Line 490: l_province pay_payroll_actions.report_qualifier%type;

486:
487: /* general process variables */
488:
489: l_report_type pay_payroll_actions.report_type%type;
490: l_province pay_payroll_actions.report_qualifier%type;
491: l_value number;
492: old_l_value number;
493: l_registration_no varchar2(150);
494: l_balance_name varchar2(150);

Line 516: pay_payroll_actions ppa

512: paa.tax_unit_id tax_unit_id,
513: ASG.effective_end_date effective_end_date
514: FROM per_all_assignments_f ASG,
515: pay_assignment_actions paa,
516: pay_payroll_actions ppa
517: WHERE ppa.payroll_action_id >= 0
518: AND ppa.effective_date between l_period_start
519: and l_period_end
520: AND ppa.action_type in ('R','Q','V','B','I')

Line 541: pay_payroll_actions ppa,

537: paa.tax_unit_id tax_unit_id,
538: ASG.effective_end_date effective_end_date
539: FROM per_all_assignments_f ASG,
540: pay_assignment_actions paa,
541: pay_payroll_actions ppa,
542: per_all_people_f ppf
543: WHERE ppa.effective_date between l_period_start
544: and l_period_end
545: AND ppa.action_type in ('R','Q','V','B','I')

Line 608: from pay_payroll_actions

604: into l_effective_date,
605: l_report_type,
606: l_bus_group_id,
607: l_legislative_parameters
608: from pay_payroll_actions
609: where payroll_action_id = pactid;
610:
611: l_eoy_tax_unit_id := pycadar_pkg.get_parameter('TRANSFER_GRE',l_legislative_parameters);
612:

Line 717: pay_payroll_actions ppa2,

713: select paa1.assignment_action_id
714: into l_max_aaid
715: from pay_assignment_actions paa1,
716: per_all_assignments_f paf2,
717: pay_payroll_actions ppa2,
718: pay_action_classifications pac2
719: where paf2.person_id = l_person_id
720: and paa1.assignment_id = paf2.assignment_id
721: and paa1.tax_unit_id = l_tax_unit_id

Line 731: pay_payroll_actions ppa,

727: and ppa2.effective_date between l_period_start and
728: l_period_end
729: and not exists (select ''
730: FROM pay_action_classifications pac,
731: pay_payroll_actions ppa,
732: pay_assignment_actions paa,
733: per_all_assignments_f paf1
734: WHERE paf1.person_id = l_person_id
735: AND paa.assignment_id = paf1.assignment_id

Line 1397: from pay_payroll_actions

1393: select to_char(effective_date,'YYYY'),
1394: add_months(trunc(effective_date, 'Y'),12) - 1
1395: into l_taxation_year,
1396: l_effective_date
1397: from pay_payroll_actions
1398: where payroll_action_id = p_payroll_action_id;
1399:
1400: exception when no_data_found then
1401: l_taxation_year := null;

Line 1898: , pay_payroll_actions run_ppa

1894: , pay_element_types_f pet
1895: , pay_input_values_f piv1
1896: , pay_input_values_f piv2
1897: , pay_assignment_actions run_paa
1898: , pay_payroll_actions run_ppa
1899: , pay_assignment_actions arch_paa
1900: , pay_payroll_actions arch_ppa
1901: , per_all_assignments_f arch_paf
1902: , per_all_assignments_f all_paf

Line 1900: , pay_payroll_actions arch_ppa

1896: , pay_input_values_f piv2
1897: , pay_assignment_actions run_paa
1898: , pay_payroll_actions run_ppa
1899: , pay_assignment_actions arch_paa
1900: , pay_payroll_actions arch_ppa
1901: , per_all_assignments_f arch_paf
1902: , per_all_assignments_f all_paf
1903: , hr_all_organization_units hou
1904: , hr_organization_information hoi

Line 1964: pay_payroll_actions ppa,

1960: CURSOR c_get_latest_asg(p_person_id number ) IS
1961: select paa.assignment_action_id
1962: from pay_assignment_actions paa,
1963: per_all_assignments_f paf,
1964: pay_payroll_actions ppa,
1965: pay_action_classifications pac
1966: where paf.person_id = p_person_id
1967: and paa.assignment_id = paf.assignment_id
1968: and paa.tax_unit_id = l_tax_unit_id

Line 1990: from pay_payroll_actions ppa,pay_assignment_actions paa

1986: /* New cursors added for Federal YE Amendment Pre-Process Validation */
1987:
1988: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
1989: select ppa.report_type
1990: from pay_payroll_actions ppa,pay_assignment_actions paa
1991: where paa.assignment_action_id = cp_locked_actid
1992: and ppa.payroll_action_id = paa.payroll_action_id;
1993:
1994: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 2091: pay_payroll_actions ppa,

2087: and paa1.tax_unit_id = l_tax_unit_id
2088: and (paa1.action_sequence , paf2.person_id) =
2089: (SELECT MAX(paa.action_sequence), paf.person_id
2090: FROM pay_action_classifications pac,
2091: pay_payroll_actions ppa,
2092: pay_assignment_actions paa,
2093: per_all_assignments_f paf1,
2094: per_all_assignments_f paf
2095: WHERE paf.assignment_id = l_asgid

Line 3672: from pay_payroll_actions

3668: select effective_date,
3669: report_type
3670: into ld_fapp_effective_date,
3671: lv_fapp_report_type
3672: from pay_payroll_actions
3673: where payroll_action_id = l_payroll_action_id;
3674:
3675: hr_utility.trace('Fed Amend Pre-Process Pactid :'||
3676: to_char(l_payroll_action_id));

Line 3766: from pay_payroll_actions

3762: into l_legislative_parameters,
3763: l_year_start,
3764: l_year_end,
3765: l_business_group
3766: from pay_payroll_actions
3767: where payroll_action_id = pactid;
3768:
3769: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
3770:

Line 3786: PPA PAY_PAYROLL_ACTIONS_N51,

3782:
3783: if l_eoy_tax_unit_id <> -99999 then
3784:
3785: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
3786: PPA PAY_PAYROLL_ACTIONS_N51,
3787: PAA PAY_ASSIGNMENT_ACTIONS_N50,
3788: ASG PER_ASSIGNMENTS_F_PK,
3789: PPA1 PAY_PAYROLL_ACTIONS_PK)
3790: USE_NL(PPY, PPA, PAA, ASG, PPA1) */

Line 3789: PPA1 PAY_PAYROLL_ACTIONS_PK)

3785: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
3786: PPA PAY_PAYROLL_ACTIONS_N51,
3787: PAA PAY_ASSIGNMENT_ACTIONS_N50,
3788: ASG PER_ASSIGNMENTS_F_PK,
3789: PPA1 PAY_PAYROLL_ACTIONS_PK)
3790: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
3791: distinct asg.person_id
3792: from pay_all_payrolls_f ppy,
3793: pay_payroll_actions ppa,

Line 3793: pay_payroll_actions ppa,

3789: PPA1 PAY_PAYROLL_ACTIONS_PK)
3790: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
3791: distinct asg.person_id
3792: from pay_all_payrolls_f ppy,
3793: pay_payroll_actions ppa,
3794: pay_assignment_actions paa,
3795: per_all_assignments_f asg,
3796: pay_payroll_actions ppa1
3797: where ppa1.payroll_action_id = :payroll_action_id

Line 3796: pay_payroll_actions ppa1

3792: from pay_all_payrolls_f ppy,
3793: pay_payroll_actions ppa,
3794: pay_assignment_actions paa,
3795: per_all_assignments_f asg,
3796: pay_payroll_actions ppa1
3797: where ppa1.payroll_action_id = :payroll_action_id
3798: and ppa.effective_date between
3799: fnd_date.canonical_to_date('''||
3800: fnd_date.date_to_canonical(l_year_start)||''') and