APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_DIMENSIONS

Line 367: (balance_dimension_id pay_balance_dimensions.balance_dimension_id%type

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

Line 368: ,dimension_name pay_balance_dimensions.dimension_name%type

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

Line 1147: l_dim_name pay_balance_dimensions.dimension_name%type;

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

Line 1259: from pay_balance_dimensions BD

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

Line 3334: from pay_balance_dimensions BD

3330: ) is
3331: select CO.context_name,
3332: BD.database_item_suffix,
3333: BD.legislation_code
3334: from pay_balance_dimensions BD
3335: ,ff_route_context_usages CU
3336: ,ff_contexts CO
3337: where BD.balance_dimension_id = p_balance_dimension_id
3338: and CU.route_id = BD.route_id

Line 3718: pay_balance_dimensions pbd,

3714: pbl.run_type_name,
3715: pbl.payroll_action_id,
3716: pbl.value
3717: from
3718: pay_balance_dimensions pbd,
3719: pay_balance_batch_lines pbl
3720: where pbl.batch_id = p_batch_id
3721: and pbl.assignment_id = p_assignment_id
3722: and pbl.balance_dimension_id = pbd.balance_dimension_id

Line 3908: from pay_balance_dimensions BD

3904: ,p_dimension_name varchar2
3905: ) is
3906: select BD.balance_dimension_id
3907: ,upper(BD.dimension_name) dimension_name
3908: from pay_balance_dimensions BD
3909: where p_balance_dimension_id is not null
3910: and BD.balance_dimension_id = p_balance_dimension_id
3911: and nvl(BD.business_group_id, nvl(p_business_group_id, -1)) =
3912: nvl(p_business_group_id, -1)

Line 3918: from pay_balance_dimensions BD

3914: nvl(p_legislation_code, ' ')
3915: union all
3916: select BD.balance_dimension_id
3917: ,upper(BD.dimension_name) dimension_name
3918: from pay_balance_dimensions BD
3919: where p_balance_dimension_id is null
3920: and upper(BD.dimension_name) = upper(p_dimension_name)
3921: and nvl(BD.business_group_id, nvl(p_business_group_id, -1)) =
3922: nvl(p_business_group_id, -1)