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.15 2008/03/21 13:13:44 avenkatk noship $*/
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.15 2008/03/21 13:13:44 avenkatk noship $*/
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 1649: /*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 */

1645:
1646: /* Bug 5461557 - Added tables piv2 and prrv2 to get input value for hours and rate and their relative joins,
1647: Used a group by based on rate */
1648:
1649: /*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 */
1650:
1651:
1652: cursor c_element_details(c_business_group_id hr_all_organization_units.organization_id%TYPE,c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1653: is

Line 1669: 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 */

1665: , 'Voluntary Deductions' , 'Post Tax Deductions'
1666: , pec.classification_name )) ||
1667: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
1668: decode(substr(piv.uom,1,1), 'M', prrv.result_value, null) amount,
1669: 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 */
1670: 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,
1671: (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)),
1672: 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 */
1673: prr.run_result_id,

Line 1670: 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,

1666: , pec.classification_name )) ||
1667: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
1668: decode(substr(piv.uom,1,1), 'M', prrv.result_value, null) amount,
1669: 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 */
1670: 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,
1671: (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)),
1672: 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 */
1673: prr.run_result_id,
1674: paa.source_action_id,

Line 1671: (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)),

1667: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges' ) label,
1668: decode(substr(piv.uom,1,1), 'M', prrv.result_value, null) amount,
1669: 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 */
1670: 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,
1671: (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)),
1672: 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 */
1673: prr.run_result_id,
1674: paa.source_action_id,
1675: paa2.tax_unit_id /*Bug 3935471*/

Line 1672: 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 */

1668: decode(substr(piv.uom,1,1), 'M', prrv.result_value, null) amount,
1669: 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 */
1670: 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,
1671: (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)),
1672: 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 */
1673: prr.run_result_id,
1674: paa.source_action_id,
1675: paa2.tax_unit_id /*Bug 3935471*/
1676: from pay_element_types_f pet

Line 2523: end pay_au_rec_det_archive;

2519: RETURN l_result;
2520: END get_element_payment_rate;
2521:
2522:
2523: end pay_au_rec_det_archive;