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 1742: FROM pay_element_entries_f peef,

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

Line 1764: FROM pay_element_entries_f peef,

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

Line 1788: FROM pay_element_entries_f peef,

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

Line 1828: pay_element_entries_f peef,

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,
1830: pay_element_types et
1831: where paa.assignment_action_id = cp_run_assignment_action_id
1832: and paa.payroll_action_id = ppa.payroll_action_id

Line 1853: FROM pay_element_entries_f peef,

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

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

2207: --bug no 6950970 ends here
2208: hr_utility.trace('lv_curr_pymt_eff_date := '|| lv_curr_pymt_eff_date);
2209: hr_utility.trace('l_date_earned := '|| l_date_earned);
2210: lv_sqlstr := 'select nvl(' || lv_application_column_name ||
2211: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id
2212: ||' AND '
2213: ||' TO_DATE('''
2214: --bug no 6950970 starts here
2215: -- || lv_curr_pymt_eff_date

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

4269: NULL
4270: ),
4271: et.element_information1
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,

Line 4296: FROM pay_element_entries_f peef,

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

Line 4771: pay_element_entries_f peef,

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,
4773: pay_element_types et
4774: where paa.assignment_action_id = cp_run_assignment_action_id
4775: and paa.payroll_action_id = ppa.payroll_action_id

Line 4788: FROM pay_element_entries_f peef,

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

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

4952: EXIT;
4953: END IF;
4954: ln_step :=53;
4955: lv_sqlstr := 'select nvl(' || p_application_column_name ||
4956: ',''AAA'') from pay_element_entries_f where element_entry_id = ' || ln_element_entry_id;
4957: execute immediate lv_sqlstr
4958: into lv_original_date_earned ;
4959:
4960: IF lv_original_date_earned = 'AAA' THEN