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

Line 138: and pay_payroll_actions via EXIST

134: amendment flag 'Y'.
135: 04-DEC-2003 PGanguly 115.50 Fixed the bug# 3298050. Changed the
136: cursor c_eoy_gre so that it checks
137: for data in the pay_assignment_actions
138: and pay_payroll_actions via EXIST
139: clause rather than direct join. Also
140: removed the tax_unit_id from the
141: select clause as this cursor selects
142: the data for a particular GRE.

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

293: sqwl_range varchar2(4000);
294: eoy_gre_range varchar2(4000);
295: eoy_all_range varchar2(4000);
296:
297: /* Returns the value of a legislative_parameter from pay_payroll_actions */
298:
299: function get_parameter(name in varchar2,
300: parameter_list varchar2)
301: return varchar2

Line 305: token_val pay_payroll_actions.legislative_parameters%type;

301: return varchar2
302: is
303: start_ptr number;
304: end_ptr number;
305: token_val pay_payroll_actions.legislative_parameters%type;
306: par_value pay_payroll_actions.legislative_parameters%type;
307: begin
308: --
309: token_val := name||'=';

Line 306: par_value pay_payroll_actions.legislative_parameters%type;

302: is
303: start_ptr number;
304: end_ptr number;
305: token_val pay_payroll_actions.legislative_parameters%type;
306: par_value pay_payroll_actions.legislative_parameters%type;
307: begin
308: --
309: token_val := name||'=';
310: --

Line 514: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

510: /* Variables used to hold the details of the payroll and assignment actions
511: that are created. */
512:
513: l_payroll_action_created boolean := false;
514: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
515: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
516:
517: /* Variable holding the balance to be tested. */
518:

Line 545: l_report_type pay_payroll_actions.report_type%type;

541: l_jurisdiction_code varchar2(30);
542:
543: /* general process variables */
544:
545: l_report_type pay_payroll_actions.report_type%type;
546: l_province pay_payroll_actions.report_qualifier%type;
547: l_value number;
548: l_effective_date date;
549: l_quarter_start date;

Line 546: l_province pay_payroll_actions.report_qualifier%type;

542:
543: /* general process variables */
544:
545: l_report_type pay_payroll_actions.report_type%type;
546: l_province pay_payroll_actions.report_qualifier%type;
547: l_value number;
548: l_effective_date date;
549: l_quarter_start date;
550: l_quarter_end date;

Line 573: FROM pay_payroll_actions ppa,

569: asg.assignment_type = 'E' AND
570: ASG.person_id between stperson and endperson AND
571: EXISTS
572: (SELECT 1
573: FROM pay_payroll_actions ppa,
574: pay_assignment_actions paa
575: WHERE
576: ppa.business_group_id = l_bus_group_id AND
577: ppa.payroll_action_id = paa.payroll_action_id AND

Line 592: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

588: CURSOR c_eoy_gre IS
589: SELECT /*+ Ordered
590: INDEX (asg PER_ASSIGNMENTS_F_N12)
591: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
592: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
593: DISTINCT ASG.person_id person_id
594: FROM
595: per_all_assignments_f ASG,
596: pay_assignment_actions paa,

Line 597: pay_payroll_actions ppa

593: DISTINCT ASG.person_id person_id
594: FROM
595: per_all_assignments_f ASG,
596: pay_assignment_actions paa,
597: pay_payroll_actions ppa
598:
599: WHERE ppa.effective_date between l_period_start
600: and l_period_end
601: and ppa.action_type in ('R','Q','V','B','I')

Line 622: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

618: per_all_assignments_f ASG,
619: pay_all_payrolls_f PPY
620: WHERE exists
621: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
622: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
623: /* 'x'
624: from pay_payroll_actions ppa,
625: pay_assignment_actions paa
626: where ppa.effective_date between l_period_start

Line 624: from pay_payroll_actions ppa,

620: WHERE exists
621: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
622: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
623: /* 'x'
624: from pay_payroll_actions ppa,
625: pay_assignment_actions paa
626: where ppa.effective_date between l_period_start
627: and l_period_end
628: and ppa.action_type in ('R','Q','V','B','I')

Line 681: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

677: CURSOR c_get_latest_asg(p_person_id number ) IS
678: select /*+ Ordered
679: INDEX (asg PER_ASSIGNMENTS_F_N12)
680: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
681: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
682: paa.assignment_action_id
683: from per_all_assignments_f paf,
684: pay_assignment_actions paa,
685: pay_payroll_actions ppa,

Line 685: pay_payroll_actions ppa,

681: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
682: paa.assignment_action_id
683: from per_all_assignments_f paf,
684: pay_assignment_actions paa,
685: pay_payroll_actions ppa,
686: pay_action_classifications pac
687: where paf.person_id = p_person_id
688: and paa.assignment_id = paf.assignment_id
689: and paa.tax_unit_id = l_tax_unit_id

Line 711: pay_payroll_actions ppa,

707: /* Original Query:
708: select paa.assignment_action_id
709: from pay_assignment_actions paa,
710: per_all_assignments_f paf,
711: pay_payroll_actions ppa,
712: pay_action_classifications pac
713: where paf.person_id = p_person_id
714: and paa.assignment_id = paf.assignment_id
715: and paa.tax_unit_id = l_tax_unit_id

Line 754: from pay_payroll_actions

750: into l_effective_date,
751: l_report_type,
752: l_bus_group_id,
753: l_legislative_parameters
754: from pay_payroll_actions
755: where payroll_action_id = pactid;
756:
757: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);
758:

Line 1592: from pay_payroll_actions

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

Line 2154: from pay_payroll_actions ppa,pay_assignment_actions paa

2150: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
2151:
2152: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
2153: select ppa.report_type
2154: from pay_payroll_actions ppa,pay_assignment_actions paa
2155: where paa.assignment_action_id = cp_locked_actid
2156: and ppa.payroll_action_id = paa.payroll_action_id;
2157:
2158: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 2182: pay_payroll_actions ppa,

2178: paa.assignment_action_id,
2179: ppa.date_earned
2180: from per_all_assignments_f paf,
2181: pay_assignment_actions paa,
2182: pay_payroll_actions ppa,
2183: pay_action_classifications pac,
2184: pay_action_contexts pac1,
2185: ff_contexts fc
2186: where paf.person_id = p_person_id

Line 2219: pay_payroll_actions ppa,

2215: ppa.date_earned
2216: from pay_assignment_actions paa,
2217: per_all_assignments_f paf,
2218: per_all_people_f ppf,
2219: pay_payroll_actions ppa,
2220: pay_action_classifications pac,
2221: pay_action_contexts pac1,
2222: ff_contexts fc
2223: where ppf.person_id = cp_person_id

Line 2398: pay_payroll_actions ppa,

2394: and paa1.tax_unit_id = l_tax_unit_id
2395: and (paa1.action_sequence , paf2.person_id) =
2396: (SELECT MAX(paa.action_sequence), paf.person_id
2397: FROM pay_action_classifications pac,
2398: pay_payroll_actions ppa,
2399: pay_assignment_actions paa,
2400: per_all_assignments_f paf1,
2401: per_all_assignments_f paf
2402: WHERE paf.assignment_id = l_asgid

Line 3667: from pay_payroll_actions

3663:
3664: hr_utility.trace('Started Federal YE Amendment PP Validation ');
3665: select effective_date,report_type
3666: into ld_fapp_effective_date,lv_fapp_report_type
3667: from pay_payroll_actions
3668: where payroll_action_id = l_payroll_action_id;
3669:
3670: hr_utility.trace('Fed Amend Pre-Process Pactid :'||
3671: to_char(l_payroll_action_id));

Line 3770: from pay_payroll_actions

3766: into l_legislative_parameters,
3767: l_year_start,
3768: l_year_end,
3769: l_business_group
3770: from pay_payroll_actions
3771: where payroll_action_id = pactid;
3772:
3773: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
3774: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);

Line 3788: PPA PAY_PAYROLL_ACTIONS_N51,

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

Line 3791: PPA1 PAY_PAYROLL_ACTIONS_PK)

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

Line 3795: pay_payroll_actions ppa,

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

Line 3798: pay_payroll_actions ppa1

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