DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_BAL_ATTRIBUTE_DEFINITIONS

Line 370: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS

366:
367: /*Bug 4132149 - Modification ends here */
368:
369: /* bug 7571001 - added get_balance_attribute cursor */
370: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS
371: select attribute_id
372: from PAY_BAL_ATTRIBUTE_DEFINITIONS
373: where attribute_name = c_attribute_name
374: ;

Line 372: from PAY_BAL_ATTRIBUTE_DEFINITIONS

368:
369: /* bug 7571001 - added get_balance_attribute cursor */
370: CURSOR get_balance_attribute (c_attribute_name PAY_BAL_ATTRIBUTE_DEFINITIONS.attribute_name%type) IS
371: select attribute_id
372: from PAY_BAL_ATTRIBUTE_DEFINITIONS
373: where attribute_name = c_attribute_name
374: ;
375:
376: /* Changes for 9147438 starts*/

Line 2995: from pay_bal_attribute_definitions pbad

2991:
2992: CURSOR c_get_fw_alw_bal_type_id IS
2993: select pbt.balance_type_id,
2994: pbt.balance_name
2995: from pay_bal_attribute_definitions pbad
2996: ,pay_balance_attributes pba
2997: ,pay_defined_balances pdb
2998: ,pay_balance_types pbt
2999: ,pay_balance_dimensions pbd