DBA Data[Home] [Help]

APPS.PAY_COSTING_SUMMARY_REP_PKG dependencies on HR_GENERAL

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

810: FROM pay_payroll_actions
811: WHERE payroll_action_id=cp_payroll_action_id;
812:
813: CURSOR c_get_accruals(cp_cost_type in VARCHAR2) IS
814: SELECT nvl(hr_general.decode_lookup('PAY_PAYRPCBR',cp_cost_type),' ')
815: FROM dual;
816:
817:
818: /************************************************************

Line 1204: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',p_cost_type),' ');

1200: CLOSE c_get_consolidation_set_name;
1201:
1202: hr_utility.set_location(gv_package_name || '.costing_summary', 30);
1203:
1204: lv_include_accruals:= nvl(hr_general.decode_lookup('PAY_PAYRPCBR',p_cost_type),' ');
1205: IF p_output_file_type='HTML' AND lv_include_accruals = ' ' THEN
1206: lv_include_accruals:=' ';
1207: END IF;
1208:

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

1414: END IF;
1415:
1416: hr_utility.trace('Record No (After Main Query) - '||c_asg_costing_details%rowcount);
1417:
1418: lv_accrual_type:=nvl(hr_general.decode_lookup('PAY_PAYRPCBR',lv_cost_mode),' ');
1419: IF p_output_file_type='HTML' AND lv_accrual_type = ' ' THEN
1420: lv_accrual_type:=' ';
1421: END IF;
1422: