APPS.PAY_PAYGTN_PKG dependencies on PAY_BALANCE_DIMENSIONS

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

677: l_er_liab_status varchar2(1); */
678: /*-- Bug#4942114 ends -- */
679:
680: cursor get_futa_def_bal_id(cp_business_group_id number) is
681: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
682: FROM pay_defined_balances pdb,
683: pay_balance_types pbt,
684: pay_balance_dimensions pbd
685: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id

Line 684: pay_balance_dimensions pbd

680: cursor get_futa_def_bal_id(cp_business_group_id number) is
681: SELECT /*+ index(pbd PAY_BALANCE_DIMENSIONS_PK)*/ pdb.defined_balance_id
682: FROM pay_defined_balances pdb,
683: pay_balance_types pbt,
684: pay_balance_dimensions pbd
685: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
686: AND pdb.balance_type_id = pbt.balance_type_id
687: AND ( pdb.business_group_id = cp_business_group_id
688: OR pdb.legislation_code = 'US'

Line 708: pay_balance_dimensions pbd

704: select count(*)
705: from pay_balance_validation pbv,
706: pay_defined_balances pdb,
707: pay_balance_types pbt,
708: pay_balance_dimensions pbd
709: where (pbv.business_group_id = cp_business_group_id)
710: and pbv.defined_balance_id = pdb.defined_balance_id
711: and pdb.balance_dimension_id = pbd.balance_dimension_id
712: and pdb.balance_type_id = pbt.balance_type_id

Line 872: pay_balance_dimensions pbd ';

868: ' and pbd.database_item_suffix ='||'''_ASG_GRE_RUN'''||
869: ' and prb.assignment_action_id = ';
870: p_er_liab_from := 'pay_run_balances prb,
871: pay_defined_balances pdb,
872: pay_balance_dimensions pbd ';
873:
874: else
875: p_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
876: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')

Line 901: pay_balance_dimensions pbd,

897: and prb.tax_unit_id = paa.tax_unit_id
898: and prb.jurisdiction_code = pst.state_code
899: and prb.tax_unit_id = paa.tax_unit_id';
900: p_wc_er_liab_from :=' pay_run_balances prb,
901: pay_balance_dimensions pbd,
902: pay_defined_balances pdb ';
903:
904: else
905: p_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id