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_TYPES_F

Line 187: data from pay_element_types_f

183: 20-OCT-2003 vpandya 115.48 3119792 Changed process_additional_elements:
184: calling populate_summary to archive
185: summary for YTD.
186: 04-OCT-2003 ahanda 115.47 3107166 Added date joins when getting
187: data from pay_element_types_f
188: 10-Sep-2003 ekim 115.46 3119792 1) Added procedure
189: 2880047 - process_additional_elements
190: 2) Moved c_prev_ytd_action_elements
191: to be global.

Line 238: from pay_element_types_f, now it is

234: Multi-Asg is 'Y' and SEPCHK = 'Y'
235: 06-FEB-2003 vpandya 115.35 2657464 Changed to get translated name of
236: an element. Changed all cursors
237: wherever reporting name is taken
238: from pay_element_types_f, now it is
239: taking from pay_element_types_f_tl.
240: Also changed populate_hours_x_rate.
241: 02-DEC-2002 ahanda 115.34 Changed package to fix GSCC warning
242: 19-NOV-2002 vpandya 115.33 Calling set_error_message function

Line 239: taking from pay_element_types_f_tl.

235: 06-FEB-2003 vpandya 115.35 2657464 Changed to get translated name of
236: an element. Changed all cursors
237: wherever reporting name is taken
238: from pay_element_types_f, now it is
239: taking from pay_element_types_f_tl.
240: Also changed populate_hours_x_rate.
241: 02-DEC-2002 ahanda 115.34 Changed package to fix GSCC warning
242: 19-NOV-2002 vpandya 115.33 Calling set_error_message function
243: of pay_emp_action_arch from all

Line 337: from pay_element_types_f pet

333: cursor c_element_info(cp_element_type_id in number
334: ,cp_effective_date in date) is
335: select pet.element_information10 primary_balance,
336: pet.element_information12 hours_balance
337: from pay_element_types_f pet
338: where pet.element_type_id = cp_element_type_id
339: and cp_effective_date between pet.effective_start_date
340: and pet.effective_end_date;
341:

Line 373: pay_element_types_f pet,

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,
375: pay_element_types_f_tl petl
376: where prr.assignment_action_id = paa.assignment_action_id
377: and paa.assignment_id = cp_assignment_id

Line 375: pay_element_types_f_tl petl

371: pay_payroll_actions ppa,
372: pay_run_results prr,
373: pay_element_types_f pet,
374: pay_element_classifications pec,
375: pay_element_types_f_tl petl
376: where prr.assignment_action_id = paa.assignment_action_id
377: and paa.assignment_id = cp_assignment_id
378: and ppa.payroll_action_id = paa.payroll_action_id
379: and ppa.action_type in (cp_action_type1, cp_action_type2, cp_action_type3)

Line 418: ,PET PAY_ELEMENT_TYPES_F_PK

414: ) is
415: select /*+ ORDERED INDEX(PRB PAY_RUN_BALANCES_N1
416: ,PDB PAY_DEFINED_BALANCES_PK
417: ,PBT PAY_BALANCE_TYPES_PK,
418: ,PET PAY_ELEMENT_TYPES_F_PK
419: ,PEC PAY_ELEMENT_CLASSIFICATION_PK
420: ,PETL PAY_ELEMENT_TYPES_F_TL_PK)
421: USE_NL(PRB, PDB, PBT, PET, PEC, PETL) */
422: distinct pec.classification_name,

Line 420: ,PETL PAY_ELEMENT_TYPES_F_TL_PK)

416: ,PDB PAY_DEFINED_BALANCES_PK
417: ,PBT PAY_BALANCE_TYPES_PK,
418: ,PET PAY_ELEMENT_TYPES_F_PK
419: ,PEC PAY_ELEMENT_CLASSIFICATION_PK
420: ,PETL PAY_ELEMENT_TYPES_F_TL_PK)
421: USE_NL(PRB, PDB, PBT, PET, PEC, PETL) */
422: distinct pec.classification_name,
423: pet.processing_priority,
424: nvl(decode(pec.classification_name,

Line 446: ,pay_element_types_f pet

442: pet.element_information12
443: from pay_run_balances prb
444: ,pay_defined_balances pdb
445: ,pay_balance_types pbt
446: ,pay_element_types_f pet
447: ,pay_element_classifications pec
448: ,pay_element_types_f_tl petl
449: where prb.effective_date >= cp_start_eff_date
450: and prb.effective_date <= cp_curr_eff_date

Line 448: ,pay_element_types_f_tl petl

444: ,pay_defined_balances pdb
445: ,pay_balance_types pbt
446: ,pay_element_types_f pet
447: ,pay_element_classifications pec
448: ,pay_element_types_f_tl petl
449: where prb.effective_date >= cp_start_eff_date
450: and prb.effective_date <= cp_curr_eff_date
451: and prb.assignment_id = cp_assignment_id
452: and pet.element_information10 is not null

Line 1305: from pay_element_types_f_tl

1301:
1302: cursor c_reporting_name(cp_element_type_id in number
1303: ,cp_language in varchar2) is
1304: select nvl(reporting_name, element_name)
1305: from pay_element_types_f_tl
1306: where element_type_id = cp_element_type_id
1307: and language = cp_language;
1308:
1309: cursor c_classification(cp_element_type_id in number ) is

Line 1313: from pay_element_types_f pet,

1309: cursor c_classification(cp_element_type_id in number ) is
1310: select pec.classification_name,
1311: pet.element_information10 primary_balance_id,
1312: pet.element_information12 hours_balance_id
1313: from pay_element_types_f pet,
1314: pay_element_classifications pec
1315: where pet.element_type_id = cp_element_type_id
1316: and p_curr_pymt_eff_date between pet.effective_start_date
1317: and pet.effective_end_date

Line 1909: pay_element_types_f pet,

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,
1911: pay_element_types_f_tl petl
1912: where paa.assignment_id = cp_assignment_id
1913: and prr.assignment_action_id = paa.assignment_action_id

Line 1911: pay_element_types_f_tl petl

1907: pay_payroll_actions ppa,
1908: pay_run_results prr,
1909: pay_element_types_f pet,
1910: pay_element_classifications pec,
1911: pay_element_types_f_tl petl
1912: where paa.assignment_id = cp_assignment_id
1913: and prr.assignment_action_id = paa.assignment_action_id
1914: and cp_sepchk_flag = 'Y'
1915: and paa.assignment_action_id = cp_pymt_action_id

Line 1960: pay_element_types_f pet,

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,
1961: pay_element_classifications pec,
1962: pay_element_types_f_tl petl
1963: where paa.assignment_id = cp_assignment_id
1964: and prr.assignment_action_id = paa.assignment_action_id

Line 1962: pay_element_types_f_tl petl

1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,
1960: pay_element_types_f pet,
1961: pay_element_classifications pec,
1962: pay_element_types_f_tl petl
1963: where paa.assignment_id = cp_assignment_id
1964: and prr.assignment_action_id = paa.assignment_action_id
1965: and cp_sepchk_flag = 'N'
1966: and pai.locking_action_id = cp_pymt_action_id

Line 2937: PAY_ELEMENT_TYPES_F PET ,

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 ,
2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032
2941: pay_run_results prr,

Line 2939: PAY_ELEMENT_TYPES_F_TL PETL

2935: PAY_PAYROLLS_F PPF,
2936: PAY_RUN_RESULTS PRR,
2937: PAY_ELEMENT_TYPES_F PET ,
2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032
2941: pay_run_results prr,
2942: pay_element_types_f pet ,
2943: pay_element_classifications pec,

Line 2942: pay_element_types_f pet ,

2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
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,

Line 2946: pay_element_types_f_tl petl,

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')
2949: and ppa.effective_date > cp_last_xfr_eff_date
2950: and ppa.effective_date <= cp_pymt_eff_date

Line 4277: pay_element_types_f et,

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')
4281: AND et.element_type_id = peef.element_type_id