APPS.PAY_PAYGTN_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 690: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id

686: l_er_liab_status varchar2(1); */
687: /*-- Bug#4942114 ends -- */
688:
689: cursor get_futa_def_bal_id(cp_business_group_id number) is
690: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
691: FROM pay_defined_balances pdb,
692: pay_balance_types pbt,
693: pay_balance_dimensions pbd
694: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id

Line 693: pay_balance_dimensions pbd

689: cursor get_futa_def_bal_id(cp_business_group_id number) is
690: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
691: FROM pay_defined_balances pdb,
692: pay_balance_types pbt,
693: pay_balance_dimensions pbd
694: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
695: AND pdb.balance_type_id = pbt.balance_type_id
696: AND ( pdb.business_group_id = cp_business_group_id
697: OR pdb.legislation_code = 'US'

Line 717: pay_balance_dimensions pbd

713: select count(*)
714: from pay_balance_validation pbv,
715: pay_defined_balances pdb,
716: pay_balance_types pbt,
717: pay_balance_dimensions pbd
718: where (pbv.business_group_id = cp_business_group_id)
719: and pbv.defined_balance_id = pdb.defined_balance_id
720: and pdb.balance_dimension_id = pbd.balance_dimension_id
721: and pdb.balance_type_id = pbt.balance_type_id

Line 881: pay_balance_dimensions pbd ';

877: ' and pbd.database_item_suffix ='||'''_ASG_GRE_RUN'''||
878: ' and prb.assignment_action_id = ';
879: p_er_liab_from := 'pay_run_balances prb,
880: pay_defined_balances pdb,
881: pay_balance_dimensions pbd ';
882:
883: else
884: p_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
885: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')

Line 910: pay_balance_dimensions pbd,

906: and prb.tax_unit_id = paa.tax_unit_id
907: and prb.jurisdiction_code = pst.state_code
908: and prb.tax_unit_id = paa.tax_unit_id';
909: p_wc_er_liab_from :=' pay_run_balances prb,
910: pay_balance_dimensions pbd,
911: pay_defined_balances pdb ';
912:
913: else
914: p_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id