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

Line 178: index(PPA,PAY_PAYROLL_ACTIONS_N51)

174: 27-OCT-2006 ahanda 115.76 5582224 Checking PL/SQL table count > 0
175: before starting loop.
176: 12-OCT-2006 ppanda 115.75 5599167 Cursor c_check_baladj changed by
177: adding hint leading(PPA)
178: index(PPA,PAY_PAYROLL_ACTIONS_N51)
179: index(PAA,PAY_ASSIGNMENT_ACTIONS_N51)
180: Cursor c_prev_elements modified by
181: adding hint
182: ORDERED use_nl(PAA, PPA, PPF)

Line 440: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)

436: ,cp_action_type3 in varchar2
437: ) is
438: select /*+ ORDERED use_nl(PAA,PPA,PPF)
439: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)
440: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
441: INDEX(prr PAY_RUN_RESULTS_N50)
442: INDEX(pcc PAY_ELEMENT_CLASSIFICATION_UK2) */
443: distinct
444: pec.classification_name,

Line 460: pay_payroll_actions ppa,

456: 'Earnings',prr.jurisdiction_code), '00-000-0000'),
457: pet.element_information10,
458: pet.element_information12
459: from pay_assignment_actions paa,
460: pay_payroll_actions ppa,
461: pay_run_results prr,
462: pay_element_types_f pet,
463: pay_element_classifications pec,
464: pay_element_types_f_tl petl

Line 843: from pay_payroll_actions ppa

839: IS
840:
841: cursor c_get_payroll_id(cp_xfr_action_id in number ) is -- added for the bug 14605761
842: select ppa.payroll_id
843: from pay_payroll_actions ppa
844: ,pay_assignment_actions paa
845: where paa.assignment_action_id=cp_xfr_action_id
846: and paa.payroll_action_id=ppa.payroll_action_id;
847:

Line 1012: from pay_payroll_actions ppa,

1008: cursor c_last_payment_info(cp_assignment_id in number
1009: ,cp_curr_pymt_eff_date in date) is
1010:
1011: select ppa.effective_date, paa.assignment_action_id
1012: from pay_payroll_actions ppa,
1013: pay_assignment_actions paa
1014: where paa.assignment_id = p_assignment_id
1015: and ppa.payroll_action_id = paa.payroll_action_id
1016: and ppa.action_type in ('R','Q')

Line 1019: ( select /+ index(ppa1, pay_payroll_Actions_pk) /

1015: and ppa.payroll_action_id = paa.payroll_action_id
1016: and ppa.action_type in ('R','Q')
1017: and ppa.effective_date < p_curr_pymt_eff_date
1018: and ppa.effective_date in
1019: ( select /*+ index(ppa1, pay_payroll_Actions_pk) */
1020: max(ppa1.effective_date)
1021: from pay_payroll_actions ppa1,
1022: pay_assignment_actions paa1
1023: where ppa1.payroll_action_id = paa1.payroll_action_id

Line 1021: from pay_payroll_actions ppa1,

1017: and ppa.effective_date < p_curr_pymt_eff_date
1018: and ppa.effective_date in
1019: ( select /*+ index(ppa1, pay_payroll_Actions_pk) */
1020: max(ppa1.effective_date)
1021: from pay_payroll_actions ppa1,
1022: pay_assignment_actions paa1
1023: where ppa1.payroll_action_id = paa1.payroll_action_id
1024: and ppa1.action_type in ('R','Q')
1025: and paa1.assignment_id = p_assignment_id

Line 1182: pay_payroll_actions ppa

1178: ,cp_sepchk_run_type_id in number) is
1179: select paa.assignment_action_id
1180: from pay_action_interlocks pai,
1181: pay_assignment_actions paa,
1182: pay_payroll_actions ppa
1183: where pai.locking_action_id = cp_pymt_assignment_action_id
1184: and paa.assignment_action_id = pai.locked_action_id
1185: and paa.payroll_action_id = ppa.payroll_action_id
1186: and ppa.action_type in ('Q','R')

Line 2048: ,pay_payroll_actions ppa_run

2044: ) IS
2045: SELECT paa_run.assignment_action_id
2046: FROM pay_action_interlocks pai
2047: ,pay_assignment_actions paa_run
2048: ,pay_payroll_actions ppa_run
2049: WHERE pai.locking_action_id = cp_pre_as_action_id
2050: AND pai.locked_action_id = paa_run.assignment_action_id
2051: AND paa_run.assignment_id = cp_assignment_id
2052: AND paa_run.payroll_action_id = ppa_run.payroll_action_id

Line 2084: pay_payroll_actions ppa,

2080: cp_element_type_id in number ) IS
2081: SELECT distinct peef.element_entry_id
2082: FROM pay_element_entries_f peef,
2083: pay_assignment_actions paa,
2084: pay_payroll_actions ppa,
2085: per_time_periods ptp
2086: WHERE paa.assignment_action_id = cp_run_action_id
2087: AND ppa.payroll_action_id = paa.payroll_action_id
2088: AND ptp.payroll_id = ppa.payroll_id

Line 2106: pay_payroll_actions ppa,

2102: cp_element_type_id in number ) IS
2103: SELECT distinct 'Y'
2104: FROM pay_element_entries_f peef,
2105: pay_assignment_actions paa,
2106: pay_payroll_actions ppa,
2107: per_time_periods ptp
2108: WHERE paa.assignment_action_id = cp_run_action_id
2109: AND ppa.payroll_action_id = paa.payroll_action_id
2110: AND ptp.payroll_id = ppa.payroll_id

Line 2130: pay_payroll_actions ppa,

2126: cp_element_type_id in number ) IS
2127: SELECT DISTINCT 'Y'
2128: FROM pay_element_entries_f peef,
2129: pay_assignment_actions paa,
2130: pay_payroll_actions ppa,
2131: per_time_periods ptp
2132: WHERE paa.assignment_action_id = cp_run_action_id
2133: AND ppa.payroll_action_id = paa.payroll_action_id
2134: AND ptp.payroll_id = ppa.payroll_id

Line 2166: pay_payroll_actions ppa,

2162: ),
2163: et.element_information1
2164: ) CATEGORY
2165: from pay_assignment_actions paa,
2166: pay_payroll_actions ppa,
2167: per_time_periods ptp,
2168: pay_element_entries_f peef,
2169: pay_element_classifications ec,
2170: pay_element_types et

Line 2209: pay_payroll_actions ppa,

2205:
2206: SELECT COUNT (*)
2207: FROM pay_element_entries_f peef,
2208: pay_assignment_actions paa,
2209: pay_payroll_actions ppa,
2210: per_time_periods ptp
2211: WHERE paa.assignment_action_id = cp_run_action_id
2212: AND ppa.payroll_action_id = paa.payroll_action_id
2213: AND ptp.payroll_id = ppa.payroll_id

Line 2264: pay_payroll_actions ppa,

2260: pet.element_information10,
2261: pet.element_information12,
2262: pet.processing_priority
2263: from pay_assignment_actions paa,
2264: pay_payroll_actions ppa,
2265: pay_run_results prr,
2266: pay_element_types_f pet,
2267: pay_element_classifications pec,
2268: pay_element_types_f_tl petl

Line 2314: pay_payroll_actions ppa,

2310: pet.element_information12,
2311: pet.processing_priority
2312: from pay_action_interlocks pai,
2313: pay_assignment_actions paa,
2314: pay_payroll_actions ppa,
2315: pay_all_payrolls_f ppf,
2316: pay_run_results prr,
2317: pay_element_types_f pet,
2318: pay_element_classifications pec,

Line 2365: pay_payroll_actions ppa

2361: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2362: SELECT
2363: TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(ppa.date_earned))),'DD-MON-YYYY')
2364: FROM pay_assignment_actions paa,
2365: pay_payroll_actions ppa
2366: WHERE paa.assignment_action_id = cp_run_action_id
2367: AND ppa.payroll_action_id = paa.payroll_action_id;
2368: l_date_earned VARCHAR2(100);
2369: --Bug 6950970 ends here

Line 2485: pay_assignment_actions paa, pay_payroll_actions ppa,

2481: END;
2482:
2483: BEGIN
2484: SELECT 'select count(peef.'|| fdv.application_column_name || ') FROM pay_element_entries_f peef,
2485: pay_assignment_actions paa, pay_payroll_actions ppa,
2486: per_time_periods ptp WHERE paa.assignment_action_id = :run_assignment_action_id '
2487: || ' AND ppa.payroll_action_id = paa.payroll_action_id
2488: AND ptp.payroll_id = ppa.payroll_id AND ppa.date_earned
2489: BETWEEN ptp.start_date AND ptp.end_date AND peef.assignment_id = '

Line 2507: pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp

2503:
2504: BEGIN
2505:
2506: SELECT 'select max(nvl(peef.'|| fdv.application_column_name || ', ptp.start_date)) FROM pay_element_entries_f peef,
2507: pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp
2508: WHERE paa.assignment_action_id = :run_assignment_action_id '
2509: ||' AND ppa.payroll_action_id = paa.payroll_action_id AND ptp.payroll_id = ppa.payroll_id
2510: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date AND
2511: peef.assignment_id = :assignment_id AND peef.element_type_id =

Line 2700: ||') FROM pay_element_entries_f peef, pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp WHERE paa.assignment_action_id = '

2696:
2697: /* Commented for bug 13905220 and redefined below
2698:
2699: lv_sqlstr1 := 'select count(peef.' || lv_application_column_name
2700: ||') FROM pay_element_entries_f peef, pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp WHERE paa.assignment_action_id = '
2701: || ln_run_assignment_action_id
2702: || ' AND ppa.payroll_action_id = paa.payroll_action_id AND ptp.payroll_id = ppa.payroll_id AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date AND peef.assignment_id = '
2703: || p_assignment_id
2704: ||' AND peef.element_type_id = '

Line 2814: pay_payroll_actions ppa

2810: pay_us_states pus,
2811: pay_us_counties puc,
2812: pay_us_city_names punc,
2813: pay_assignment_actions paa,
2814: pay_payroll_actions ppa
2815: WHERE peaf.assignment_id = p_assignment_id
2816: AND paa.assignment_action_id = ln_run_assignment_action_id
2817: AND peaf.location_id = hla.location_id
2818: AND hla.region_2 = pus.state_abbrev

Line 3429: PAY_PAYROLL_ACTIONS PPA,

3425: 'Tax Deductions', prr.jurisdiction_code), '00-000-0000'),
3426: pet.element_information10,
3427: pet.element_information12
3428: from PAY_ASSIGNMENT_ACTIONS PAA,
3429: PAY_PAYROLL_ACTIONS PPA,
3430: PAY_PAYROLLS_F PPF,
3431: PAY_RUN_RESULTS PRR,
3432: PAY_ELEMENT_TYPES_F PET ,
3433: PAY_ELEMENT_CLASSIFICATIONS PEC,

Line 3440: pay_payroll_actions ppa,

3436: pay_run_results prr,
3437: pay_element_types_f pet ,
3438: pay_element_classifications pec,
3439: pay_assignment_actions paa,
3440: pay_payroll_actions ppa,
3441: pay_element_types_f_tl petl,
3442: pay_all_payrolls_f ppf */ -- Bug 3370112
3443: where ppa.action_type in ('R', 'Q', 'B')
3444: and ppa.effective_date > cp_last_xfr_eff_date

Line 4643: , pay_payroll_actions ppa

4639: ,cp_curr_eff_date in date) is
4640: select /*+ ORDERED */
4641: min(ppa.effective_date)
4642: from pay_assignment_actions paa
4643: , pay_payroll_actions ppa
4644: where ppa.action_type = 'B'
4645: and paa.payroll_action_id = ppa.payroll_action_id
4646: and paa.action_status = 'C'
4647: and paa.assignment_action_id > cp_xfr_action_id

Line 4769: pay_payroll_actions ppa,

4765: et.element_information1
4766: ) CATEGORY
4767: from pay_element_entries_f peef,
4768: per_time_periods ptp,
4769: pay_payroll_actions ppa,
4770: pay_assignment_actions paa,
4771: pay_element_types_f et,
4772: pay_element_classifications ec
4773: where peef.element_entry_id = cp_element_entry_id

Line 4798: pay_payroll_actions ppa,

4794: peef.creator_type,
4795: peef.source_start_date
4796: FROM pay_element_entries_f peef,
4797: pay_assignment_actions paa,
4798: pay_payroll_actions ppa,
4799: per_time_periods ptp
4800: WHERE paa.assignment_action_id = cp_run_action_id
4801: AND ppa.payroll_action_id = paa.payroll_action_id
4802: AND ptp.payroll_id = ppa.payroll_id

Line 5130: pay_payroll_actions ppa

5126: pay_us_states pus,
5127: pay_us_counties puc,
5128: pay_us_city_names punc,
5129: pay_assignment_actions paa,
5130: pay_payroll_actions ppa
5131: WHERE peaf.assignment_id = p_assignment_id
5132: AND paa.assignment_action_id = p_run_assignment_action_id
5133: AND peaf.location_id = hla.location_id
5134: AND hla.region_2 = pus.state_abbrev

Line 5379: pay_payroll_actions ppa,

5375: ),
5376: et.element_information1
5377: ) CATEGORY
5378: from pay_assignment_actions paa,
5379: pay_payroll_actions ppa,
5380: per_time_periods ptp,
5381: pay_element_entries_f peef,
5382: pay_element_classifications ec,
5383: pay_element_types et

Line 5401: pay_payroll_actions ppa,

5397: peef.creator_type,
5398: peef.source_start_date
5399: FROM pay_element_entries_f peef,
5400: pay_assignment_actions paa,
5401: pay_payroll_actions ppa,
5402: per_time_periods ptp
5403: WHERE paa.assignment_action_id = cp_run_action_id
5404: AND ppa.payroll_action_id = paa.payroll_action_id
5405: AND ptp.payroll_id = ppa.payroll_id

Line 5555: lv_sqlstr1 := 'select max(nvl(peef.' || p_application_column_name ||', ptp.start_date)) FROM pay_element_entries_f peef, pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp WHERE paa.assignment_action_id =' ;

5551:
5552: ln_ytd_hours := 0;
5553: ln_amount := 0;
5554:
5555: lv_sqlstr1 := 'select max(nvl(peef.' || p_application_column_name ||', ptp.start_date)) FROM pay_element_entries_f peef, pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp WHERE paa.assignment_action_id =' ;
5556: lv_sqlstr2 := p_run_assignment_action_id ;
5557: lv_sqlstr3 :='AND ppa.payroll_action_id = paa.payroll_action_id AND ptp.payroll_id = ppa.payroll_id AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date AND peef.assignment_id =' || p_assignment_id ||'AND peef.element_type_id =' ;
5558: lv_sqlstr4 := p_element_type_id ||' AND NVL(ppa.date_earned, ppa.effective_date) BETWEEN peef.effective_start_date AND peef.effective_end_date AND peef.' || p_application_column_name || ' is not null ' ;
5559: lv_sqlstr_final := lv_sqlstr1 || lv_sqlstr2 || lv_sqlstr3 || lv_sqlstr4 ;

Line 5685: pay_payroll_actions ppa

5681: pay_us_states pus,
5682: pay_us_counties puc,
5683: pay_us_city_names punc,
5684: pay_assignment_actions paa,
5685: pay_payroll_actions ppa
5686: WHERE peaf.assignment_id = p_assignment_id
5687: AND paa.assignment_action_id = p_run_assignment_action_id
5688: AND peaf.location_id = hla.location_id
5689: AND hla.region_2 = pus.state_abbrev

Line 5979: pay_payroll_actions ppa,

5975: ),
5976: et.element_information1
5977: ) CATEGORY
5978: from pay_assignment_actions paa,
5979: pay_payroll_actions ppa,
5980: per_time_periods ptp,
5981: pay_element_entries_f peef,
5982: pay_element_classifications ec,
5983: pay_element_types et

Line 6002: pay_payroll_actions ppa,

5998: peef.creator_type,
5999: peef.source_start_date
6000: FROM pay_element_entries_f peef,
6001: pay_assignment_actions paa,
6002: pay_payroll_actions ppa,
6003: per_time_periods ptp
6004: WHERE paa.assignment_action_id = cp_run_action_id
6005: AND ppa.payroll_action_id = paa.payroll_action_id
6006: AND ptp.payroll_id = ppa.payroll_id

Line 6297: pay_payroll_actions ppa

6293: pay_us_states pus,
6294: pay_us_counties puc,
6295: pay_us_city_names punc,
6296: pay_assignment_actions paa,
6297: pay_payroll_actions ppa
6298: WHERE peaf.assignment_id = p_assignment_id
6299: AND paa.assignment_action_id = p_run_assignment_action_id
6300: AND peaf.location_id = hla.location_id
6301: AND hla.region_2 = pus.state_abbrev