DBA Data[Home] [Help]

APPS.PAY_COSTING_SUMMARY_X_REP_PKG dependencies on HR_GENERAL

Line 280: SELECT nvl(hr_general.decode_lookup('PAY_PAYRPCBR',cp_cost_type),' ')

276: FROM pay_payroll_actions
277: WHERE payroll_action_id=cp_payroll_action_id;
278: --
279: CURSOR c_get_accruals(cp_cost_type IN VARCHAR2) IS
280: SELECT nvl(hr_general.decode_lookup('PAY_PAYRPCBR',cp_cost_type),' ')
281: FROM dual;
282: --
283:
284: /************************************************************

Line 569: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',

565: CLOSE c_get_consolidation_set_name;
566:
567: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
568:
569: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',
570: p_cost_type),' ');
571:
572: IF p_costing IS NOT NULL THEN
573: OPEN c_get_effective_date(TO_NUMBER(p_costing));

Line 786: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');

782: 'C_G_ASG_COSTING_DETAILS_NODATA',
783: '0');
784: END IF;
785: l_rec_count := l_rec_count + 1;
786: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
787: /*insert into pay_us_rpt_totals*/
788: insert INTO pay_us_rpt_totals(session_id,business_group_id,gre_name,value1,
789: value2 ,attribute1,attribute2,attribute3,
790: attribute4,attribute5,attribute6,attribute7,