APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_DIMENSIONS

Line 365: (balance_dimension_id pay_balance_dimensions.balance_dimension_id%type

361: index by binary_integer;
362:
363:
364: type t_dimension_validation_rec is record
365: (balance_dimension_id pay_balance_dimensions.balance_dimension_id%type
366: ,dimension_name pay_balance_dimensions.dimension_name%type
367: ,invld boolean -- does the dimension exist ?
368: ,not_supp boolean -- is it supported ?
369: ,jc_cntxt boolean -- does it use JURISDICTION_CODE ?

Line 366: ,dimension_name pay_balance_dimensions.dimension_name%type

362:
363:
364: type t_dimension_validation_rec is record
365: (balance_dimension_id pay_balance_dimensions.balance_dimension_id%type
366: ,dimension_name pay_balance_dimensions.dimension_name%type
367: ,invld boolean -- does the dimension exist ?
368: ,not_supp boolean -- is it supported ?
369: ,jc_cntxt boolean -- does it use JURISDICTION_CODE ?
370: ,gre_cntxt boolean -- does it use TAX_UNIT_ID ?

Line 1145: l_dim_name pay_balance_dimensions.dimension_name%type;

1141: p_legislation_code in varchar2
1142: ,p_dimension_name in varchar2
1143: ) return varchar2 is
1144: --
1145: l_dim_name pay_balance_dimensions.dimension_name%type;
1146: l_is_supported boolean;
1147: statem varchar2(256);
1148: dim_not_supp number;
1149: --

Line 1257: from pay_balance_dimensions BD

1253: -- Count the number of contexts used by the balance dimension.
1254: --
1255: select count(CU.context_id)
1256: into l_no_contexts
1257: from pay_balance_dimensions BD
1258: ,ff_route_context_usages CU
1259: where CU.route_id = BD.route_id
1260: and BD.balance_dimension_id = p_balance_dimension_id;
1261: --

Line 3041: from pay_balance_dimensions BD

3037: ) is
3038: select CO.context_name,
3039: BD.database_item_suffix,
3040: BD.legislation_code
3041: from pay_balance_dimensions BD
3042: ,ff_route_context_usages CU
3043: ,ff_contexts CO
3044: where BD.balance_dimension_id = p_balance_dimension_id
3045: and CU.route_id = BD.route_id

Line 3425: pay_balance_dimensions pbd,

3421: pbl.run_type_name,
3422: pbl.payroll_action_id,
3423: pbl.value
3424: from
3425: pay_balance_dimensions pbd,
3426: pay_balance_batch_lines pbl
3427: where pbl.batch_id = p_batch_id
3428: and pbl.assignment_id = p_assignment_id
3429: and pbl.balance_dimension_id = pbd.balance_dimension_id

Line 3615: from pay_balance_dimensions BD

3611: ,p_dimension_name varchar2
3612: ) is
3613: select BD.balance_dimension_id
3614: ,upper(BD.dimension_name) dimension_name
3615: from pay_balance_dimensions BD
3616: where p_balance_dimension_id is not null
3617: and BD.balance_dimension_id = p_balance_dimension_id
3618: and nvl(BD.business_group_id, nvl(p_business_group_id, -1)) =
3619: nvl(p_business_group_id, -1)

Line 3625: from pay_balance_dimensions BD

3621: nvl(p_legislation_code, ' ')
3622: union all
3623: select BD.balance_dimension_id
3624: ,upper(BD.dimension_name) dimension_name
3625: from pay_balance_dimensions BD
3626: where p_balance_dimension_id is null
3627: and upper(BD.dimension_name) = upper(p_dimension_name)
3628: and nvl(BD.business_group_id, nvl(p_business_group_id, -1)) =
3629: nvl(p_business_group_id, -1)