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

360: sqwl_range varchar2(4000);
361: eoy_gre_range varchar2(4000);
362: eoy_all_range varchar2(4000);
363:
364: /* Returns the value of a legislative_parameter from pay_payroll_actions */
365:
366: function get_parameter(name in varchar2,
367: parameter_list varchar2)
368: return varchar2

Line 372: token_val pay_payroll_actions.legislative_parameters%type;

368: return varchar2
369: is
370: start_ptr number;
371: end_ptr number;
372: token_val pay_payroll_actions.legislative_parameters%type;
373: par_value pay_payroll_actions.legislative_parameters%type;
374: begin
375: --
376: token_val := name||'=';

Line 373: par_value pay_payroll_actions.legislative_parameters%type;

369: is
370: start_ptr number;
371: end_ptr number;
372: token_val pay_payroll_actions.legislative_parameters%type;
373: par_value pay_payroll_actions.legislative_parameters%type;
374: begin
375: --
376: token_val := name||'=';
377: --

Line 581: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

577: /* Variables used to hold the details of the payroll and assignment actions
578: that are created. */
579:
580: l_payroll_action_created boolean := false;
581: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
582: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
583:
584: /* Variable holding the balance to be tested. */
585:

Line 612: l_report_type pay_payroll_actions.report_type%type;

608: l_jurisdiction_code varchar2(30);
609:
610: /* general process variables */
611:
612: l_report_type pay_payroll_actions.report_type%type;
613:
614: -- Variables declared for bug 10399514
615: l_person_on boolean ;
616: l_report_cat pay_payroll_actions.report_category%type;

Line 616: l_report_cat pay_payroll_actions.report_category%type;

612: l_report_type pay_payroll_actions.report_type%type;
613:
614: -- Variables declared for bug 10399514
615: l_person_on boolean ;
616: l_report_cat pay_payroll_actions.report_category%type;
617: l_state pay_payroll_actions.report_qualifier%type;
618: l_report_format pay_report_format_mappings_f.report_format%type;
619: -- Variables declared for bug 10399514
620:

Line 617: l_state pay_payroll_actions.report_qualifier%type;

613:
614: -- Variables declared for bug 10399514
615: l_person_on boolean ;
616: l_report_cat pay_payroll_actions.report_category%type;
617: l_state pay_payroll_actions.report_qualifier%type;
618: l_report_format pay_report_format_mappings_f.report_format%type;
619: -- Variables declared for bug 10399514
620:
621: l_province pay_payroll_actions.report_qualifier%type;

Line 621: l_province pay_payroll_actions.report_qualifier%type;

617: l_state pay_payroll_actions.report_qualifier%type;
618: l_report_format pay_report_format_mappings_f.report_format%type;
619: -- Variables declared for bug 10399514
620:
621: l_province pay_payroll_actions.report_qualifier%type;
622: l_value number;
623: l_effective_date date;
624: l_quarter_start date;
625: l_quarter_end date;

Line 648: FROM pay_payroll_actions ppa,

644: asg.assignment_type = 'E' AND
645: ASG.person_id between stperson and endperson AND
646: EXISTS
647: (SELECT 1
648: FROM pay_payroll_actions ppa,
649: pay_assignment_actions paa
650: WHERE
651: ppa.business_group_id = l_bus_group_id AND
652: ppa.payroll_action_id = paa.payroll_action_id AND

Line 667: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

663: CURSOR c_eoy_gre IS
664: SELECT /*+ Ordered
665: INDEX (asg PER_ASSIGNMENTS_F_N12)
666: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
667: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
668: DISTINCT ASG.person_id person_id
669: FROM
670: per_all_assignments_f ASG,
671: pay_assignment_actions paa,

Line 672: pay_payroll_actions ppa

668: DISTINCT ASG.person_id person_id
669: FROM
670: per_all_assignments_f ASG,
671: pay_assignment_actions paa,
672: pay_payroll_actions ppa
673:
674: WHERE ppa.effective_date between l_period_start
675: and l_period_end
676: and ppa.action_type in ('R','Q','V','B','I')

Line 699: pay_payroll_actions ppa,

695: DISTINCT ASG.person_id person_id
696: FROM
697: per_all_assignments_f ASG,
698: pay_assignment_actions paa,
699: pay_payroll_actions ppa,
700: pay_population_ranges ppr
701: WHERE ppa.effective_date between l_period_start
702: and l_period_end
703: and ppa.action_type in ('R','Q','V','B','I')

Line 727: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

723: per_all_assignments_f ASG,
724: pay_all_payrolls_f PPY
725: WHERE exists
726: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
727: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
728: /* 'x'
729: from pay_payroll_actions ppa,
730: pay_assignment_actions paa
731: where ppa.effective_date between l_period_start

Line 729: from pay_payroll_actions ppa,

725: WHERE exists
726: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
727: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
728: /* 'x'
729: from pay_payroll_actions ppa,
730: pay_assignment_actions paa
731: where ppa.effective_date between l_period_start
732: and l_period_end
733: and ppa.action_type in ('R','Q','V','B','I')

Line 786: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

782: CURSOR c_get_latest_asg(p_person_id number ) IS
783: select /*+ Ordered
784: INDEX (asg PER_ASSIGNMENTS_F_N12)
785: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
786: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
787: paa.assignment_action_id
788: from per_all_assignments_f paf,
789: pay_assignment_actions paa,
790: pay_payroll_actions ppa,

Line 790: pay_payroll_actions ppa,

786: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
787: paa.assignment_action_id
788: from per_all_assignments_f paf,
789: pay_assignment_actions paa,
790: pay_payroll_actions ppa,
791: pay_action_classifications pac
792: where paf.person_id = p_person_id
793: and paa.assignment_id = paf.assignment_id
794: and paa.tax_unit_id = l_tax_unit_id

Line 816: pay_payroll_actions ppa,

812: /* Original Query:
813: select paa.assignment_action_id
814: from pay_assignment_actions paa,
815: per_all_assignments_f paf,
816: pay_payroll_actions ppa,
817: pay_action_classifications pac
818: where paf.person_id = p_person_id
819: and paa.assignment_id = paf.assignment_id
820: and paa.tax_unit_id = l_tax_unit_id

Line 867: from pay_payroll_actions

863: l_report_cat,
864: -- Added for bug 10399514
865: l_bus_group_id,
866: l_legislative_parameters
867: from pay_payroll_actions
868: where payroll_action_id = pactid;
869:
870: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);
871:

Line 1810: from pay_payroll_actions

1806: select to_char(effective_date,'YYYY'),
1807: add_months(trunc(effective_date, 'Y'),12) - 1
1808: into l_taxation_year,
1809: l_effective_date
1810: from pay_payroll_actions
1811: where payroll_action_id = p_payroll_action_id;
1812:
1813: exception when no_data_found then
1814: l_taxation_year := null;

Line 2385: pay_payroll_actions ppa,

2381:
2382: cursor c_balance_feed_info (p_balance_name varchar2,p_each_asgid number) is
2383: select nvl(pet.element_information20,'NOT FOUND'),pbtl.balance_name,rv.result_value
2384: from pay_assignment_actions pa,
2385: pay_payroll_actions ppa,
2386: per_all_assignments_f paf,
2387: pay_element_types_f pet,
2388: pay_run_results r,
2389: pay_run_result_values rv,

Line 2443: from pay_payroll_actions ppa,pay_assignment_actions paa

2439: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
2440:
2441: CURSOR c_get_fapp_lkd_actid_rtype(cp_locked_actid number) IS
2442: select ppa.report_type
2443: from pay_payroll_actions ppa,pay_assignment_actions paa
2444: where paa.assignment_action_id = cp_locked_actid
2445: and ppa.payroll_action_id = paa.payroll_action_id;
2446:
2447: CURSOR c_get_fapp_locked_action_id(cp_locking_act_id number) IS

Line 2471: pay_payroll_actions ppa,

2467: paa.assignment_action_id,
2468: ppa.date_earned
2469: from per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc
2475: where paf.person_id = p_person_id

Line 2508: pay_payroll_actions ppa,

2504: ppa.date_earned
2505: from pay_assignment_actions paa,
2506: per_all_assignments_f paf,
2507: per_all_people_f ppf,
2508: pay_payroll_actions ppa,
2509: pay_action_classifications pac,
2510: pay_action_contexts pac1,
2511: ff_contexts fc
2512: where ppf.person_id = cp_person_id

Line 2704: pay_payroll_actions ppa,

2700: and paa1.tax_unit_id = l_tax_unit_id
2701: and (paa1.action_sequence , paf2.person_id) =
2702: (SELECT MAX(paa.action_sequence), paf.person_id
2703: FROM pay_action_classifications pac,
2704: pay_payroll_actions ppa,
2705: pay_assignment_actions paa,
2706: per_all_assignments_f paf1,
2707: per_all_assignments_f paf
2708: WHERE paf.assignment_id = l_asgid

Line 4294: from pay_payroll_actions

4290:
4291: hr_utility.trace('Started Federal YE Amendment PP Validation ');
4292: select effective_date,report_type
4293: into ld_fapp_effective_date,lv_fapp_report_type
4294: from pay_payroll_actions
4295: where payroll_action_id = l_payroll_action_id;
4296:
4297: hr_utility.trace('Fed Amend Pre-Process Pactid :'||
4298: to_char(l_payroll_action_id));

Line 4397: from pay_payroll_actions

4393: into l_legislative_parameters,
4394: l_year_start,
4395: l_year_end,
4396: l_business_group
4397: from pay_payroll_actions
4398: where payroll_action_id = pactid;
4399:
4400: hr_utility.trace('legislative prameter is '|| l_legislative_parameters);
4401: l_eoy_tax_unit_id := get_parameter('TRANSFER_GRE',l_legislative_parameters);

Line 4415: PPA PAY_PAYROLL_ACTIONS_N51,

4411:
4412: if l_eoy_tax_unit_id <> -99999 then
4413:
4414: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
4415: PPA PAY_PAYROLL_ACTIONS_N51,
4416: PAA PAY_ASSIGNMENT_ACTIONS_N50,
4417: ASG PER_ASSIGNMENTS_F_PK,
4418: PPA1 PAY_PAYROLL_ACTIONS_PK)
4419: USE_NL(PPY, PPA, PAA, ASG, PPA1) */

Line 4418: PPA1 PAY_PAYROLL_ACTIONS_PK)

4414: sqlstr := 'select /*+ ORDERED INDEX (PPY PAY_PAYROLLS_F_FK2,
4415: PPA PAY_PAYROLL_ACTIONS_N51,
4416: PAA PAY_ASSIGNMENT_ACTIONS_N50,
4417: ASG PER_ASSIGNMENTS_F_PK,
4418: PPA1 PAY_PAYROLL_ACTIONS_PK)
4419: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
4420: distinct asg.person_id
4421: from pay_all_payrolls_f ppy,
4422: pay_payroll_actions ppa,

Line 4422: pay_payroll_actions ppa,

4418: PPA1 PAY_PAYROLL_ACTIONS_PK)
4419: USE_NL(PPY, PPA, PAA, ASG, PPA1) */
4420: distinct asg.person_id
4421: from pay_all_payrolls_f ppy,
4422: pay_payroll_actions ppa,
4423: pay_assignment_actions paa,
4424: per_all_assignments_f asg,
4425: pay_payroll_actions ppa1
4426: where ppa1.payroll_action_id = :payroll_action_id

Line 4425: pay_payroll_actions ppa1

4421: from pay_all_payrolls_f ppy,
4422: pay_payroll_actions ppa,
4423: pay_assignment_actions paa,
4424: per_all_assignments_f asg,
4425: pay_payroll_actions ppa1
4426: where ppa1.payroll_action_id = :payroll_action_id
4427: and ppa.effective_date between
4428: fnd_date.canonical_to_date('''||
4429: fnd_date.date_to_canonical(l_year_start)||''') and