APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_BALANCE_DIMENSIONS

Line 1126: pay_balance_dimensions pbd

1122: CURSOR csr_get_def_bal_type_id(c_balance_name VARCHAR2,c_dimension_name VARCHAR2) IS
1123: SELECT defined_balance_id
1124: FROM pay_defined_balances pdb,
1125: pay_balance_types pbt,
1126: pay_balance_dimensions pbd
1127: WHERE pbt.balance_name =c_balance_name
1128: AND pbd.legislation_code='NL'
1129: AND pbd.DIMENSION_NAME=c_dimension_name
1130: AND pdb.balance_type_id = pbt.balance_type_id

Line 1934: FROM pay_balance_dimensions

1930:
1931: -- Get the Assignment Run level dimension id
1932: CURSOR csr_asg_dimId IS
1933: SELECT balance_dimension_id
1934: FROM pay_balance_dimensions
1935: WHERE legislation_code = 'NL'
1936: AND database_item_suffix = '_ASG_RUN';
1937:
1938: -- Get the Legislation Code and Curreny Code

Line 4893: pay_balance_dimensions pbd

4889: CURSOR csr_get_def_bal_type_id(c_balance_name VARCHAR2,c_dimension_name VARCHAR2) IS
4890: SELECT defined_balance_id
4891: FROM pay_defined_balances pdb,
4892: pay_balance_types pbt,
4893: pay_balance_dimensions pbd
4894: WHERE
4895: pbt.balance_name =c_balance_name
4896: and pbd.legislation_code='NL'
4897: and pbd.DIMENSION_NAME=c_dimension_name