APPS.PY_ZA_BAL dependencies on PAY_BALANCE_DIMENSIONS

Line 291: pay_balance_dimensions pbd

287: cursor relevant(c_balance_type_id IN NUMBER,
288: c_db_item_suffix IN VARCHAR2) IS
289: select pdb.defined_balance_id from
290: pay_defined_balances pdb,
291: pay_balance_dimensions pbd
292: where pdb.balance_dimension_id = pbd.balance_dimension_id
293: and pbd.database_item_suffix = c_db_item_suffix
294: and pdb.balance_type_id = c_balance_type_id;
295: --

Line 489: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;

485: l_to_date DATE;
486: l_regular_payment_date DATE;
487: l_action_sequence NUMBER;
488: l_business_group_id NUMBER;
489: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
490: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
491: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
492: l_latest_value_exists VARCHAR(2);
493: --

Line 490: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;

486: l_regular_payment_date DATE;
487: l_action_sequence NUMBER;
488: l_business_group_id NUMBER;
489: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
490: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
491: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
492: l_latest_value_exists VARCHAR(2);
493: --
494: cursor c1 (c_asg_action_id IN NUMBER,

Line 491: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;

487: l_action_sequence NUMBER;
488: l_business_group_id NUMBER;
489: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
490: l_database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE;
491: l_legislation_code pay_balance_dimensions.legislation_code%TYPE;
492: l_latest_value_exists VARCHAR(2);
493: --
494: cursor c1 (c_asg_action_id IN NUMBER,
495: c_defined_balance_id IN NUMBER)is

Line 525: pay_balance_dimensions DIM

521: DIM.database_item_suffix ,
522: DIM.legislation_code
523: FROM
524: pay_defined_balances DB,
525: pay_balance_dimensions DIM
526: WHERE DB.defined_balance_id = p_defined_balance_id
527: AND DIM.balance_dimension_id = DB.balance_dimension_id;
528: --
529: BEGIN

Line 638: from pay_balance_dimensions pbd,

634: --
635: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
636: select pdb.balance_type_id,
637: pbd.dimension_name
638: from pay_balance_dimensions pbd,
639: pay_defined_balances pdb
640: where pdb.defined_balance_id = c_defined_balance_id
641: and pdb.balance_dimension_id = pbd.balance_dimension_id;
642: --

Line 717: from pay_balance_dimensions pbd,

713: --
714: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
715: select pdb.balance_type_id,
716: pbd.dimension_name
717: from pay_balance_dimensions pbd,
718: pay_defined_balances pdb
719: where pdb.defined_balance_id = c_defined_balance_id
720: and pdb.balance_dimension_id = pbd.balance_dimension_id;
721: --

Line 2994: pay_balance_dimensions_s.NEXTVAL

2990: l_route_text ff_routes.text%TYPE;
2991: l_bal_next number;
2992: BEGIN
2993: SELECT
2994: pay_balance_dimensions_s.NEXTVAL
2995: INTO
2996: l_bal_next
2997: FROM DUAL;
2998:

Line 3124: INSERT INTO pay_balance_dimensions

3120: -- Find the current request id
3121: l_req_id := fnd_profile.value('CONC_REQUEST_ID');
3122:
3123: -- insert into the table
3124: INSERT INTO pay_balance_dimensions
3125: (
3126: balance_dimension_id,
3127: business_group_id,
3128: legislation_code,

Line 3143: pay_balance_dimensions_s.CURRVAL,

3139: feed_checking_type
3140: )
3141: VALUES
3142: (
3143: pay_balance_dimensions_s.CURRVAL,
3144: p_business_group_id,
3145: NULL,
3146: ff_routes_s.CURRVAL,
3147: p_suffix,

Line 3353: pay_balance_dimensions pbd

3349: c_db_item_suffix IN VARCHAR2)
3350: IS
3351: SELECT pdb.defined_balance_id
3352: FROM pay_defined_balances pdb,
3353: pay_balance_dimensions pbd
3354: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
3355: AND pbd.database_item_suffix = c_db_item_suffix
3356: AND pdb.balance_type_id = c_balance_type_id;
3357: --

Line 3520: pay_balance_dimensions pbd

3516: c_db_item_suffix IN VARCHAR2)
3517: IS
3518: SELECT pdb.defined_balance_id
3519: FROM pay_defined_balances pdb,
3520: pay_balance_dimensions pbd
3521: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
3522: AND pbd.database_item_suffix = c_db_item_suffix
3523: AND pdb.balance_type_id = c_balance_type_id;
3524: