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 276: data from pay_element_types_f

272: 20-OCT-2003 vpandya 115.48 3119792 Changed process_additional_elements:
273: calling populate_summary to archive
274: summary for YTD.
275: 04-OCT-2003 ahanda 115.47 3107166 Added date joins when getting
276: data from pay_element_types_f
277: 10-Sep-2003 ekim 115.46 3119792 1) Added procedure
278: 2880047 - process_additional_elements
279: 2) Moved c_prev_ytd_action_elements
280: to be global.

Line 327: from pay_element_types_f, now it is

323: Multi-Asg is 'Y' and SEPCHK = 'Y'
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

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 426: from pay_element_types_f pet

422: cursor c_element_info(cp_element_type_id in number
423: ,cp_effective_date in date) is
424: select pet.element_information10 primary_balance,
425: pet.element_information12 hours_balance
426: from pay_element_types_f pet
427: where pet.element_type_id = cp_element_type_id
428: and cp_effective_date between pet.effective_start_date
429: and pet.effective_end_date;
430:

Line 462: pay_element_types_f pet,

458: pet.element_information12
459: from pay_assignment_actions paa,
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

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 527: ,pay_element_types_f pet

523: ,4,'0')))), '00-000-0000') jurisdiction_code,
524: pet.element_information10,
525: pet.element_information12
526: from pay_element_classifications pec
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

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 1621: from pay_element_types_f pet,

1617: cursor c_classification(cp_element_type_id in number ) is
1618: select pec.classification_name,
1619: pet.element_information10 primary_balance_id,
1620: pet.element_information12 hours_balance_id
1621: from pay_element_types_f pet,
1622: pay_element_classifications pec
1623: where pet.element_type_id = cp_element_type_id
1624: and p_curr_pymt_eff_date between pet.effective_start_date
1625: and pet.effective_end_date

Line 2266: pay_element_types_f pet,

2262: pet.processing_priority
2263: from pay_assignment_actions paa,
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

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 2317: pay_element_types_f pet,

2313: pay_assignment_actions paa,
2314: pay_payroll_actions ppa,
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

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 3432: PAY_ELEMENT_TYPES_F PET ,

3428: from PAY_ASSIGNMENT_ACTIONS PAA,
3429: PAY_PAYROLL_ACTIONS PPA,
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,

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 3437: 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,
3439: pay_assignment_actions paa,
3440: pay_payroll_actions ppa,
3441: pay_element_types_f_tl petl,

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

Line 4771: pay_element_types_f et,

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,
4772: pay_element_classifications ec
4773: where peef.element_entry_id = cp_element_entry_id
4774: AND peef.creator_type IN ('EE', 'NR', 'PR', 'R', 'RR')
4775: AND et.element_type_id = peef.element_type_id