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 90: index(PAA,PAY_ASSIGNMENT_ACTIONS_N51)

86: before starting loop.
87: 12-OCT-2006 ppanda 115.75 5599167 Cursor c_check_baladj changed by
88: adding hint leading(PPA)
89: index(PPA,PAY_PAYROLL_ACTIONS_N51)
90: index(PAA,PAY_ASSIGNMENT_ACTIONS_N51)
91: Cursor c_prev_elements modified by
92: adding hint
93: ORDERED use_nl(PAA, PPA, PPF)
94: 19-SEP-2006 sodhingr 115.74 5549032 Added ORDERED hint to c_prev_elements

Line 350: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)

346: ,cp_action_type2 in varchar2
347: ,cp_action_type3 in varchar2
348: ) is
349: select /*+ ORDERED use_nl(PAA,PPA,PPF)
350: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)
351: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
352: INDEX(prr PAY_RUN_RESULTS_N50)
353: INDEX(pcc PAY_ELEMENT_CLASSIFICATION_UK2) */
354: distinct

Line 370: from pay_assignment_actions paa,

366: 'Tax Deductions', prr.jurisdiction_code,
367: 'Earnings',prr.jurisdiction_code), '00-000-0000'),
368: pet.element_information10,
369: pet.element_information12
370: from pay_assignment_actions paa,
371: pay_payroll_actions ppa,
372: pay_run_results prr,
373: pay_element_types_f pet,
374: pay_element_classifications pec,

Line 742: pay_assignment_actions paa

738: ,cp_curr_pymt_eff_date in date) is
739:
740: select ppa.effective_date, paa.assignment_action_id
741: from pay_payroll_actions ppa,
742: pay_assignment_actions paa
743: where paa.assignment_id = p_assignment_id
744: and ppa.payroll_action_id = paa.payroll_action_id
745: and ppa.action_type in ('R','Q')
746: and ppa.effective_date < p_curr_pymt_eff_date

Line 751: pay_assignment_actions paa1

747: and ppa.effective_date in
748: ( select /*+ index(ppa1, pay_payroll_Actions_pk) */
749: max(ppa1.effective_date)
750: from pay_payroll_actions ppa1,
751: pay_assignment_actions paa1
752: where ppa1.payroll_action_id = paa1.payroll_action_id
753: and ppa1.action_type in ('R','Q')
754: and paa1.assignment_id = p_assignment_id
755: and ppa1.effective_date < p_curr_pymt_eff_date);

Line 910: pay_assignment_actions paa,

906: cursor c_non_sep_check(cp_pymt_assignment_action_id in number
907: ,cp_sepchk_run_type_id in number) is
908: select paa.assignment_action_id
909: from pay_action_interlocks pai,
910: pay_assignment_actions paa,
911: pay_payroll_actions ppa
912: where pai.locking_action_id = cp_pymt_assignment_action_id
913: and paa.assignment_action_id = pai.locked_action_id
914: and paa.payroll_action_id = ppa.payroll_action_id

Line 1275: from pay_assignment_actions paa,

1271: cursor c_run_aa_id(cp_pymt_action_id in number
1272: ,cp_assignment_id in number ) is
1273: select paa.assignment_action_id
1274: ,paa.run_type_id
1275: from pay_assignment_actions paa,
1276: pay_action_interlocks pai
1277: where pai.locking_action_id = cp_pymt_action_id
1278: and paa.assignment_action_id = pai.locked_action_id
1279: and paa.assignment_id = cp_assignment_id

Line 1730: FROM pay_action_interlocks pai, pay_assignment_actions paa,

1726: CURSOR get_run_action_id(cp_pre_as_action_id in number,
1727: cp_assignment_id in number
1728: ) IS
1729: SELECT paa.assignment_action_id
1730: FROM pay_action_interlocks pai, pay_assignment_actions paa,
1731: pay_payroll_actions ppa
1732: WHERE pai.locking_action_id =cp_pre_as_action_id
1733: AND pai.locked_action_id = paa.assignment_action_id
1734: AND paa.assignment_id = cp_assignment_id

Line 1743: pay_assignment_actions paa,

1739: cp_assignment_id in number ,
1740: cp_element_type_id in number ) IS
1741: SELECT distinct peef.element_entry_id
1742: FROM pay_element_entries_f peef,
1743: pay_assignment_actions paa,
1744: pay_payroll_actions ppa,
1745: per_time_periods ptp
1746: WHERE paa.assignment_action_id = cp_run_action_id
1747: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1765: pay_assignment_actions paa,

1761: cp_assignment_id in number ,
1762: cp_element_type_id in number ) IS
1763: SELECT distinct 'Y'
1764: FROM pay_element_entries_f peef,
1765: pay_assignment_actions paa,
1766: pay_payroll_actions ppa,
1767: per_time_periods ptp
1768: WHERE paa.assignment_action_id = cp_run_action_id
1769: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1789: pay_assignment_actions paa,

1785: cp_assignment_id in number ,
1786: cp_element_type_id in number ) IS
1787: SELECT DISTINCT 'Y'
1788: FROM pay_element_entries_f peef,
1789: pay_assignment_actions paa,
1790: pay_payroll_actions ppa,
1791: per_time_periods ptp
1792: WHERE paa.assignment_action_id = cp_run_action_id
1793: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1825: from pay_assignment_actions paa,

1821: NULL
1822: ),
1823: et.element_information1
1824: ) CATEGORY
1825: from pay_assignment_actions paa,
1826: pay_payroll_actions ppa,
1827: per_time_periods ptp,
1828: pay_element_entries_f peef,
1829: pay_element_classifications ec,

Line 1854: pay_assignment_actions paa,

1850: cp_element_type_id IN NUMBER) IS
1851:
1852: SELECT COUNT (*)
1853: FROM pay_element_entries_f peef,
1854: pay_assignment_actions paa,
1855: pay_payroll_actions ppa,
1856: per_time_periods ptp
1857: WHERE paa.assignment_action_id = cp_run_action_id
1858: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1906: from pay_assignment_actions paa,

1902: nvl(petl.reporting_name, petl.element_name),
1903: pet.element_information10,
1904: pet.element_information12,
1905: pet.processing_priority
1906: from pay_assignment_actions paa,
1907: pay_payroll_actions ppa,
1908: pay_run_results prr,
1909: pay_element_types_f pet,
1910: pay_element_classifications pec,

Line 1956: pay_assignment_actions paa,

1952: pet.element_information10,
1953: pet.element_information12,
1954: pet.processing_priority
1955: from pay_action_interlocks pai,
1956: pay_assignment_actions paa,
1957: pay_payroll_actions ppa,
1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,
1960: pay_element_types_f pet,

Line 2001: from pay_assignment_actions paa

1997: order by pec.classification_name;
1998:
1999: cursor c_ytd_action_seq(cp_asg_act_id in number) is
2000: select paa.action_sequence
2001: from pay_assignment_actions paa
2002: where paa.assignment_action_id = cp_asg_act_id;
2003: --Bug 6950970 starts here
2004: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2005: SELECT

Line 2007: FROM pay_assignment_actions paa,

2003: --Bug 6950970 starts here
2004: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2005: SELECT
2006: TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(ppa.date_earned))),'DD-MON-YYYY')
2007: FROM pay_assignment_actions paa,
2008: pay_payroll_actions ppa
2009: WHERE paa.assignment_action_id = cp_run_action_id
2010: AND ppa.payroll_action_id = paa.payroll_action_id;
2011: l_date_earned VARCHAR2(100);

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

2229:
2230: -- Possibility of Malformed SQL (Added Spaces between)
2231:
2232: lv_sqlstr1 := 'select count(peef.' || lv_application_column_name
2233: ||') FROM pay_element_entries_f peef, pay_assignment_actions paa, pay_payroll_actions ppa,per_time_periods ptp WHERE paa.assignment_action_id = '
2234: || ln_run_assignment_action_id
2235: || ' 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 = '
2236: || p_assignment_id
2237: ||' AND peef.element_type_id = '

Line 2333: pay_assignment_actions paa,

2329: hr_locations_all hla,
2330: pay_us_states pus,
2331: pay_us_counties puc,
2332: pay_us_city_names punc,
2333: pay_assignment_actions paa,
2334: pay_payroll_actions ppa
2335: WHERE peaf.assignment_id = p_assignment_id
2336: AND paa.assignment_action_id = ln_run_assignment_action_id
2337: AND peaf.location_id = hla.location_id

Line 2933: from PAY_ASSIGNMENT_ACTIONS PAA,

2929: nvl(decode(pec.classification_name,
2930: 'Tax Deductions', prr.jurisdiction_code), '00-000-0000'),
2931: pet.element_information10,
2932: pet.element_information12
2933: from PAY_ASSIGNMENT_ACTIONS PAA,
2934: PAY_PAYROLL_ACTIONS PPA,
2935: PAY_PAYROLLS_F PPF,
2936: PAY_RUN_RESULTS PRR,
2937: PAY_ELEMENT_TYPES_F PET ,

Line 2944: pay_assignment_actions paa,

2940: /*changing the order for bug 5549032
2941: pay_run_results prr,
2942: pay_element_types_f pet ,
2943: pay_element_classifications pec,
2944: pay_assignment_actions paa,
2945: pay_payroll_actions ppa,
2946: pay_element_types_f_tl petl,
2947: pay_all_payrolls_f ppf */ -- Bug 3370112
2948: where ppa.action_type in ('R', 'Q', 'B')

Line 4146: index(PAA, PAY_ASSIGNMENT_ACTIONS_N51) */

4142: ,cp_payroll_id in number
4143: ,cp_consolidation_set_id in number
4144: ,cp_curr_eff_date in date) is
4145: select /*+ leading(PPA) index(PPA, PAY_PAYROLL_ACTIONS_N51)
4146: index(PAA, PAY_ASSIGNMENT_ACTIONS_N51) */
4147: min(ppa.effective_date)
4148: from pay_payroll_actions ppa
4149: ,pay_assignment_actions paa
4150: where ppa.action_type = 'B'

Line 4149: ,pay_assignment_actions paa

4145: select /*+ leading(PPA) index(PPA, PAY_PAYROLL_ACTIONS_N51)
4146: index(PAA, PAY_ASSIGNMENT_ACTIONS_N51) */
4147: min(ppa.effective_date)
4148: from pay_payroll_actions ppa
4149: ,pay_assignment_actions paa
4150: where ppa.action_type = 'B'
4151: and paa.payroll_action_id = ppa.payroll_action_id
4152: and paa.action_status = 'C'
4153: and paa.assignment_action_id > cp_xfr_action_id

Line 4276: pay_assignment_actions paa,

4272: ) CATEGORY
4273: from pay_element_entries_f peef,
4274: per_time_periods ptp,
4275: pay_payroll_actions ppa,
4276: pay_assignment_actions paa,
4277: pay_element_types_f et,
4278: pay_element_classifications ec
4279: where peef.element_entry_id = cp_element_entry_id
4280: AND peef.creator_type IN ('EE', 'NR', 'PR', 'R', 'RR')

Line 4297: pay_assignment_actions paa,

4293: SELECT peef.element_entry_id,
4294: peef.creator_type,
4295: peef.source_start_date
4296: FROM pay_element_entries_f peef,
4297: pay_assignment_actions paa,
4298: pay_payroll_actions ppa,
4299: per_time_periods ptp
4300: WHERE paa.assignment_action_id = cp_run_action_id
4301: AND ppa.payroll_action_id = paa.payroll_action_id

Line 4526: pay_assignment_actions paa,

4522: hr_locations_all hla,
4523: pay_us_states pus,
4524: pay_us_counties puc,
4525: pay_us_city_names punc,
4526: pay_assignment_actions paa,
4527: pay_payroll_actions ppa
4528: WHERE peaf.assignment_id = p_assignment_id
4529: AND paa.assignment_action_id = p_run_assignment_action_id
4530: AND peaf.location_id = hla.location_id

Line 4768: from pay_assignment_actions paa,

4764: NULL
4765: ),
4766: et.element_information1
4767: ) CATEGORY
4768: from pay_assignment_actions paa,
4769: pay_payroll_actions ppa,
4770: per_time_periods ptp,
4771: pay_element_entries_f peef,
4772: pay_element_classifications ec,

Line 4789: pay_assignment_actions paa,

4785: select peef.element_entry_id,
4786: peef.creator_type,
4787: peef.source_start_date
4788: FROM pay_element_entries_f peef,
4789: pay_assignment_actions paa,
4790: pay_payroll_actions ppa,
4791: per_time_periods ptp
4792: WHERE paa.assignment_action_id = cp_run_action_id
4793: AND ppa.payroll_action_id = paa.payroll_action_id

Line 4934: 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 =' ;

4930:
4931: ln_ytd_hours := 0;
4932: ln_amount := 0;
4933:
4934: 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 =' ;
4935: lv_sqlstr2 := p_run_assignment_action_id ;
4936: 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 =' ;
4937: 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 ' ;
4938: lv_sqlstr_final := lv_sqlstr1 || lv_sqlstr2 || lv_sqlstr3 || lv_sqlstr4 ;

Line 5061: pay_assignment_actions paa,

5057: hr_locations_all hla,
5058: pay_us_states pus,
5059: pay_us_counties puc,
5060: pay_us_city_names punc,
5061: pay_assignment_actions paa,
5062: pay_payroll_actions ppa
5063: WHERE peaf.assignment_id = p_assignment_id
5064: AND paa.assignment_action_id = p_run_assignment_action_id
5065: AND peaf.location_id = hla.location_id