APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 351: ,balance_name pay_balance_types.balance_name%type

347: index by binary_integer;
348:
349: type t_balance_validation_rec is record
350: (balance_type_id number
351: ,balance_name pay_balance_types.balance_name%type
352: ,element_type_id number
353: ,element_link_id number
354: ,ibf_input_value_id number
355: ,jc_input_value_id number

Line 2358: CURSOR c_wcb_balance(p_balance_type_id pay_balance_types.balance_type_id%type) IS

2354: ,TBA.balance_type_id;
2355:
2356: -- WCB balances, bug 11657441
2357:
2358: CURSOR c_wcb_balance(p_balance_type_id pay_balance_types.balance_type_id%type) IS
2359: SELECT 'Y' from pay_balance_types
2360: where BALANCE_TYPE_ID = p_balance_type_id
2361: and BALANCE_NAME in ('WCB ER Liability','WCB Gross','WCB Pre Tax Reductions',
2362: 'WCB Subject','WCB Taxable');

Line 2359: SELECT 'Y' from pay_balance_types

2355:
2356: -- WCB balances, bug 11657441
2357:
2358: CURSOR c_wcb_balance(p_balance_type_id pay_balance_types.balance_type_id%type) IS
2359: SELECT 'Y' from pay_balance_types
2360: where BALANCE_TYPE_ID = p_balance_type_id
2361: and BALANCE_NAME in ('WCB ER Liability','WCB Gross','WCB Pre Tax Reductions',
2362: 'WCB Subject','WCB Taxable');
2363: -- WCB balances, bug 11657441

Line 4501: from pay_balance_types BT

4497: ,p_balance_name varchar2
4498: ) is
4499: select BT.balance_type_id
4500: ,upper(BT.balance_name) balance_name
4501: from pay_balance_types BT
4502: where p_balance_type_id is not null
4503: and BT.balance_type_id = p_balance_type_id
4504: and nvl(BT.business_group_id, nvl(p_business_group_id, -1)) =
4505: nvl(p_business_group_id, -1)

Line 4511: from pay_balance_types BT

4507: nvl(p_legislation_code, ' ')
4508: union all
4509: select BT.balance_type_id
4510: ,upper(BT.balance_name) balance_name
4511: from pay_balance_types BT
4512: where p_balance_type_id is null
4513: and upper(BT.balance_name) = upper(p_balance_name)
4514: and nvl(BT.business_group_id, nvl(p_business_group_id, -1)) =
4515: nvl(p_business_group_id, -1)

Line 4535: from pay_balance_types BT

4531: ,IV.input_value_id ibf_input_value_id
4532: ,decode(nvl(BT.jurisdiction_level, 0),
4533: 0, null,
4534: IV2.input_value_id) jc_input_value_id
4535: from pay_balance_types BT
4536: ,pay_balance_feeds_f BF
4537: ,pay_input_values_f IV
4538: ,pay_input_values_f IV2
4539: ,pay_element_types_f ET

Line 5354: pay_balance_types BT

5350: is
5351: select distinct TBA1.batch_line_id
5352: from pay_temp_balance_adjustments TBA1,
5353: pay_temp_balance_adjustments TBA2,
5354: pay_balance_types BT
5355: where TBA1.batch_line_id <> TBA2.batch_line_id
5356: and TBA1.adjustment_date = TBA2.adjustment_date
5357: and TBA1.balance_type_id = TBA2.balance_type_id
5358: and TBA1.adjustment_amount <> 0