DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ELEMENT_TYPES_F_TL

Line 328: taking from pay_element_types_f_tl.

324: 06-FEB-2003 vpandya 115.35 2657464 Changed to get translated name of
325: an element. Changed all cursors
326: wherever reporting name is taken
327: from pay_element_types_f, now it is
328: taking from pay_element_types_f_tl.
329: Also changed populate_hours_x_rate.
330: 02-DEC-2002 ahanda 115.34 Changed package to fix GSCC warning
331: 19-NOV-2002 vpandya 115.33 Calling set_error_message function
332: of pay_emp_action_arch from all

Line 464: pay_element_types_f_tl petl

460: pay_payroll_actions ppa,
461: pay_run_results prr,
462: pay_element_types_f pet,
463: pay_element_classifications pec,
464: pay_element_types_f_tl petl
465: where prr.assignment_action_id = paa.assignment_action_id
466: and paa.assignment_id = cp_assignment_id
467: and ppa.payroll_action_id = paa.payroll_action_id
468: and ppa.action_type in (cp_action_type1, cp_action_type2, cp_action_type3)

Line 531: ,pay_element_types_f_tl petl

527: ,pay_element_types_f pet
528: ,pay_balance_types pbt
529: ,pay_defined_balances pdb
530: ,pay_run_balances prb
531: ,pay_element_types_f_tl petl
532: where prb.effective_date >= cp_start_eff_date
533: and prb.effective_date <= cp_curr_eff_date
534: and prb.assignment_id = cp_assignment_id
535: and pet.element_information10 is not null

Line 1613: from pay_element_types_f_tl

1609:
1610: cursor c_reporting_name(cp_element_type_id in number
1611: ,cp_language in varchar2) is
1612: select nvl(reporting_name, element_name)
1613: from pay_element_types_f_tl
1614: where element_type_id = cp_element_type_id
1615: and language = cp_language;
1616:
1617: cursor c_classification(cp_element_type_id in number ) is

Line 2268: pay_element_types_f_tl petl

2264: pay_payroll_actions ppa,
2265: pay_run_results prr,
2266: pay_element_types_f pet,
2267: pay_element_classifications pec,
2268: pay_element_types_f_tl petl
2269: where paa.assignment_id = cp_assignment_id
2270: and prr.assignment_action_id = paa.assignment_action_id
2271: and cp_sepchk_flag = 'Y'
2272: and paa.assignment_action_id = cp_pymt_action_id

Line 2319: pay_element_types_f_tl petl

2315: pay_all_payrolls_f ppf,
2316: pay_run_results prr,
2317: pay_element_types_f pet,
2318: pay_element_classifications pec,
2319: pay_element_types_f_tl petl
2320: where paa.assignment_id = cp_assignment_id
2321: and prr.assignment_action_id = paa.assignment_action_id
2322: and cp_sepchk_flag = 'N'
2323: and pai.locking_action_id = cp_pymt_action_id

Line 3434: PAY_ELEMENT_TYPES_F_TL PETL

3430: PAY_PAYROLLS_F PPF,
3431: PAY_RUN_RESULTS PRR,
3432: PAY_ELEMENT_TYPES_F PET ,
3433: PAY_ELEMENT_CLASSIFICATIONS PEC,
3434: PAY_ELEMENT_TYPES_F_TL PETL
3435: /*changing the order for bug 5549032
3436: pay_run_results prr,
3437: pay_element_types_f pet ,
3438: pay_element_classifications pec,

Line 3441: pay_element_types_f_tl petl,

3437: pay_element_types_f pet ,
3438: pay_element_classifications pec,
3439: pay_assignment_actions paa,
3440: pay_payroll_actions ppa,
3441: pay_element_types_f_tl petl,
3442: pay_all_payrolls_f ppf */ -- Bug 3370112
3443: where ppa.action_type in ('R', 'Q', 'B')
3444: and ppa.effective_date > cp_last_xfr_eff_date
3445: and ppa.effective_date <= cp_pymt_eff_date