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_ELEMENT_ENTRIES_F

Line 2082: FROM pay_element_entries_f peef,

2078: Cursor get_element_entry_id( cp_run_action_id in number ,
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

Line 2104: FROM pay_element_entries_f peef,

2100: Cursor check_retro( cp_run_action_id in number ,
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

Line 2128: FROM pay_element_entries_f peef,

2124: CURSOR retro_parent_check_flag ( cp_run_action_id in number ,
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

Line 2168: pay_element_entries_f peef,

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
2172: and paa.payroll_action_id = ppa.payroll_action_id

Line 2207: FROM pay_element_entries_f peef,

2203: cp_assignment_id IN NUMBER,
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

Line 2468: from pay_element_entries_f where element_entry_id = :element_entry_id '

2464: -- Code added by sneelapa for bug 13905220 starts here.
2465:
2466: BEGIN
2467: SELECT 'select nvl('|| fdv.application_column_name || ',''AAA'')
2468: from pay_element_entries_f where element_entry_id = :element_entry_id '
2469: ||' AND '
2470: ||' TO_DATE( :date_earned , ''DD-MON-YYYY'') '
2471: ||' BETWEEN effective_start_date AND effective_end_date '
2472: into lv_sqlstr

Line 2484: SELECT 'select count(peef.'|| fdv.application_column_name || ') FROM pay_element_entries_f peef,

2480: hr_utility.trace('Error occurred while preparing query for lv_sqlstr ');
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

Line 2506: SELECT 'select max(nvl(peef.'|| fdv.application_column_name || ', ptp.start_date)) FROM pay_element_entries_f peef,

2502: END;
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

Line 2527: from pay_element_entries_f where element_entry_id = :element_entry_id '

2523: END;
2524:
2525: BEGIN
2526: SELECT 'select nvl('|| fdv.application_column_name || ',''AAA'')
2527: from pay_element_entries_f where element_entry_id = :element_entry_id '
2528: into lv_sqlstr_date
2529: FROM fnd_descr_flex_col_usage_vl fdv
2530: WHERE fdv.application_id = 801
2531: AND fdv.descriptive_flexfield_name LIKE 'PAY_ELEMENT_ENTRIES'

Line 2665: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id

2661:
2662: /* Commented for bug 13905220
2663:
2664: lv_sqlstr := 'select nvl(' || lv_application_column_name ||
2665: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id
2666: ||' AND '
2667: ||' TO_DATE('''
2668: --bug no 6950970 starts here
2669: -- || lv_curr_pymt_eff_date

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 4767: from pay_element_entries_f peef,

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

Line 4796: FROM pay_element_entries_f peef,

4792: cp_element_type_id in number ) IS
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

Line 5381: pay_element_entries_f peef,

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
5385: and paa.payroll_action_id = ppa.payroll_action_id

Line 5399: FROM pay_element_entries_f peef,

5395: cp_element_type_id in number ) IS
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

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 5577: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id;

5573: EXIT;
5574: END IF;
5575: ln_step :=53;
5576: lv_sqlstr := 'select nvl(' || p_application_column_name ||
5577: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id;
5578: execute immediate lv_sqlstr
5579: into lv_original_date_earned ;
5580:
5581: IF lv_original_date_earned = 'AAA' THEN

Line 5981: pay_element_entries_f peef,

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
5985: and paa.payroll_action_id = ppa.payroll_action_id

Line 6000: FROM pay_element_entries_f peef,

5996: cp_element_type_id in number ) IS
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