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_ASSIGNMENT_ACTIONS

Line 179: index(PAA,PAY_ASSIGNMENT_ACTIONS_N51)

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)
183: 19-SEP-2006 sodhingr 115.74 5549032 Added ORDERED hint to c_prev_elements

Line 439: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)

435: ,cp_action_type2 in varchar2
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

Line 459: from pay_assignment_actions paa,

455: 'Tax Deductions', prr.jurisdiction_code,
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,

Line 844: ,pay_assignment_actions paa

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:
848: cursor c_prev_run_information(cp_assignment_id in number

Line 1013: pay_assignment_actions paa

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')
1017: and ppa.effective_date < p_curr_pymt_eff_date

Line 1022: pay_assignment_actions paa1

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
1026: and ppa1.effective_date < p_curr_pymt_eff_date);

Line 1181: pay_assignment_actions paa,

1177: cursor c_non_sep_check(cp_pymt_assignment_action_id in number
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

Line 1583: from pay_assignment_actions paa,

1579: cursor c_run_aa_id(cp_pymt_action_id in number
1580: ,cp_assignment_id in number ) is
1581: select paa.assignment_action_id
1582: ,paa.run_type_id
1583: from pay_assignment_actions paa,
1584: pay_action_interlocks pai
1585: where pai.locking_action_id = cp_pymt_action_id
1586: and paa.assignment_action_id = pai.locked_action_id
1587: and paa.assignment_id = cp_assignment_id

Line 2047: ,pay_assignment_actions paa_run

2043: ,cp_element_type_id in number --#11897283
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

Line 2063: FROM pay_assignment_actions paa_run2

2059: and paa_run.run_type_id <> cp_sepchk_run_type_id))
2060: /* Added for Bug#9207953 */
2061: /* AND NOT EXISTS
2062: ( SELECT 1
2063: FROM pay_assignment_actions paa_run2
2064: WHERE paa_run2.run_type_id is not null
2065: AND paa_run2.source_action_id is not null
2066: AND paa_run2.source_action_id = paa_run.source_action_id
2067: AND paa_run2.run_type_id = cp_sepchk_run_type_id

Line 2083: pay_assignment_actions paa,

2079: cp_assignment_id in number ,
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

Line 2105: pay_assignment_actions paa,

2101: cp_assignment_id in number ,
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

Line 2129: pay_assignment_actions paa,

2125: cp_assignment_id in number ,
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

Line 2165: from pay_assignment_actions paa,

2161: NULL
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,

Line 2208: pay_assignment_actions paa,

2204: cp_element_type_id IN NUMBER) IS
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

Line 2263: from pay_assignment_actions paa,

2259: nvl(petl.reporting_name, petl.element_name),
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,

Line 2313: pay_assignment_actions paa,

2309: pet.element_information10,
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,

Line 2358: from pay_assignment_actions paa

2354: order by pec.classification_name;
2355:
2356: cursor c_ytd_action_seq(cp_asg_act_id in number) is
2357: select paa.action_sequence
2358: from pay_assignment_actions paa
2359: where paa.assignment_action_id = cp_asg_act_id;
2360: --Bug 6950970 starts here
2361: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2362: SELECT

Line 2364: FROM pay_assignment_actions paa,

2360: --Bug 6950970 starts here
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);

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 2813: pay_assignment_actions paa,

2809: hr_locations_all hla,
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

Line 3428: from PAY_ASSIGNMENT_ACTIONS PAA,

3424: nvl(decode(pec.classification_name,
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 ,

Line 3439: pay_assignment_actions paa,

3435: /*changing the order for bug 5549032
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')

Line 4642: from pay_assignment_actions paa

4638: ,cp_consolidation_set_id in number
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'

Line 4770: pay_assignment_actions paa,

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
4774: AND peef.creator_type IN ('EE', 'NR', 'PR', 'R', 'RR')

Line 4797: pay_assignment_actions paa,

4793: SELECT peef.element_entry_id,
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

Line 5129: pay_assignment_actions paa,

5125: hr_locations_all hla,
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

Line 5378: from pay_assignment_actions paa,

5374: NULL
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,

Line 5400: pay_assignment_actions paa,

5396: select peef.element_entry_id,
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

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 5684: pay_assignment_actions paa,

5680: hr_locations_all hla,
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

Line 5978: from pay_assignment_actions paa,

5974: NULL
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,

Line 6001: pay_assignment_actions paa,

5997: select peef.element_entry_id,
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

Line 6296: pay_assignment_actions paa,

6292: hr_locations_all hla,
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