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 683: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',

679: CLOSE c_get_consolidation_set_name;
680:
681: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
682:
683: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',
684: p_cost_type),' ');
685:
686: IF p_costing IS NOT NULL THEN
687: OPEN c_get_effective_date(TO_NUMBER(p_costing));

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

955: 'C_G_ASG_COSTING_DETAILS_NODATA',
956: '0');
957: END IF;
958: l_rec_count := l_rec_count + 1;
959: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
960: /*insert into pay_us_rpt_totals*/
961: insert into pay_us_rpt_totals(session_id,business_group_id,gre_name,value1 ,value2 ,attribute1,attribute2
962: ,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8
963: ,attribute9,attribute10,attribute11,attribute12,attribute13