APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ELEMENT_TYPES_F_TL

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 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 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 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 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 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 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 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