APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 349: ,balance_name pay_balance_types.balance_name%type

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

Line 4208: from pay_balance_types BT

4204: ,p_balance_name varchar2
4205: ) is
4206: select BT.balance_type_id
4207: ,upper(BT.balance_name) balance_name
4208: from pay_balance_types BT
4209: where p_balance_type_id is not null
4210: and BT.balance_type_id = p_balance_type_id
4211: and nvl(BT.business_group_id, nvl(p_business_group_id, -1)) =
4212: nvl(p_business_group_id, -1)

Line 4218: from pay_balance_types BT

4214: nvl(p_legislation_code, ' ')
4215: union all
4216: select BT.balance_type_id
4217: ,upper(BT.balance_name) balance_name
4218: from pay_balance_types BT
4219: where p_balance_type_id is null
4220: and upper(BT.balance_name) = upper(p_balance_name)
4221: and nvl(BT.business_group_id, nvl(p_business_group_id, -1)) =
4222: nvl(p_business_group_id, -1)

Line 4242: from pay_balance_types BT

4238: ,IV.input_value_id ibf_input_value_id
4239: ,decode(nvl(BT.jurisdiction_level, 0),
4240: 0, null,
4241: IV2.input_value_id) jc_input_value_id
4242: from pay_balance_types BT
4243: ,pay_balance_feeds_f BF
4244: ,pay_input_values_f IV
4245: ,pay_input_values_f IV2
4246: ,pay_element_types_f ET

Line 5061: pay_balance_types BT

5057: is
5058: select distinct TBA1.batch_line_id
5059: from pay_temp_balance_adjustments TBA1,
5060: pay_temp_balance_adjustments TBA2,
5061: pay_balance_types BT
5062: where TBA1.batch_line_id <> TBA2.batch_line_id
5063: and TBA1.adjustment_date = TBA2.adjustment_date
5064: and TBA1.balance_type_id = TBA2.balance_type_id
5065: and TBA1.adjustment_amount <> 0