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 PER_TIME_PERIODS

Line 2085: per_time_periods ptp

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
2089: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 2107: per_time_periods ptp

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
2111: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 2131: per_time_periods ptp

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
2135: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 2167: per_time_periods ptp,

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
2171: where paa.assignment_action_id = cp_run_assignment_action_id

Line 2210: per_time_periods ptp

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
2214: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 2486: per_time_periods ptp WHERE paa.assignment_action_id = :run_assignment_action_id '

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 = '
2490: ||' :assignment_id AND peef.element_type_id = :element_type_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 4768: per_time_periods ptp,

4764: ),
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

Line 4799: per_time_periods ptp

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
4803: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

Line 5380: per_time_periods ptp,

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
5384: where paa.assignment_action_id = cp_run_assignment_action_id

Line 5402: per_time_periods ptp

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
5406: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date

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 5980: per_time_periods ptp,

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
5984: where paa.assignment_action_id = cp_run_assignment_action_id

Line 6003: per_time_periods ptp

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
6007: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date