DBA Data[Home] [Help]

APPS.PAY_PURGE_PKG dependencies on PAY_BALANCE_UPLOAD

Line 1192: and pay_balance_upload.dim_is_supported

1188: where bsm.balance_set_id = p_balance_set_id
1189: and pdb.defined_balance_id = bsm.defined_balance_id
1190: and pbt.balance_type_id = pdb.balance_type_id
1191: and pbd.balance_dimension_id = pdb.balance_dimension_id
1192: and pay_balance_upload.dim_is_supported
1193: (p_legislation_code, pbd.dimension_name) = 'Y'
1194: union /* do not return duplicates */
1195: select pbt.balance_type_id,
1196: pbt.balance_name,

Line 1226: and pay_balance_upload.dim_is_supported

1222: and pdb.defined_balance_id = fue.creator_id
1223: and pbd.balance_dimension_id = pdb.balance_dimension_id
1224: and pbd.dimension_level = 'ASG'
1225: and pbd.period_type = 'LIFETIME'
1226: and pay_balance_upload.dim_is_supported
1227: (p_legislation_code, pbd.dimension_name) = 'Y'
1228: and pbt.balance_type_id = pdb.balance_type_id
1229: order by 1; -- balance_type_id.
1230: