APPS.PAY_AU_REC_DET_ARCHIVE dependencies on PAY_AU_REC_DET_ARCHIVE

Line 1: package body pay_au_rec_det_archive as

1: package body pay_au_rec_det_archive as
2: /* $Header: pyaurecd.pkb 120.20 2010/08/04 06:58:36 pmatamsr ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_rec_det_archive (Package Body)

Line 5: *** Program: pay_au_rec_det_archive (Package Body)

1: package body pay_au_rec_det_archive as
2: /* $Header: pyaurecd.pkb 120.20 2010/08/04 06:58:36 pmatamsr ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_rec_det_archive (Package Body)
6: ***
7: *** Change History
8: ***
9: *** Date Changed By Version Bug No Description of Change

Line 2848: /*Bug 5603254 - Removed tables piv2 and prrv2 and their joins from cursor , added a call to function pay_au_rec_det_archive.get_element_payment_hours to get the value for hours and rate */

2844:
2845: /* Bug 5461557 - Added tables piv2 and prrv2 to get input value for hours and rate and their relative joins,
2846: Used a group by based on rate */
2847:
2848: /*Bug 5603254 - Removed tables piv2 and prrv2 and their joins from cursor , added a call to function pay_au_rec_det_archive.get_element_payment_hours to get the value for hours and rate */
2849: /*Bug 9147421 - Added check for element classification 'Foreign Tax Deductions'
2850: - Negate the amount for foreign tax deductions and classify as Tax Deductions
2851: */
2852:

Line 2873: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */

2869: , 'Foreign Tax Deductions' , 'Tax Deductions'
2870: , pec.classification_name )) ||
2871: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
2872: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv.result_value,0)), prrv.result_value) amount,
2873: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2874: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2875: (prrv.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2876: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2877: prr.run_result_id,

Line 2874: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,

2870: , pec.classification_name )) ||
2871: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
2872: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv.result_value,0)), prrv.result_value) amount,
2873: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2874: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2875: (prrv.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2876: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2877: prr.run_result_id,
2878: paa.source_action_id,

Line 2875: (prrv.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),

2871: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
2872: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv.result_value,0)), prrv.result_value) amount,
2873: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2874: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2875: (prrv.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2876: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2877: prr.run_result_id,
2878: paa.source_action_id,
2879: paa2.tax_unit_id /*Bug 3935471*/

Line 2876: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */

2872: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv.result_value,0)), prrv.result_value) amount,
2873: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2874: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2875: (prrv.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2876: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2877: prr.run_result_id,
2878: paa.source_action_id,
2879: paa2.tax_unit_id /*Bug 3935471*/
2880: from pay_element_types_f pet

Line 3727: end pay_au_rec_det_archive;

3723: RETURN l_result;
3724: END get_element_payment_rate;
3725:
3726:
3727: end pay_au_rec_det_archive;