APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_BALANCE_FEEDS_F

Line 617: FROM pay_balance_feeds_f

613: /* Gets the balance feeds attached with the input value of retro element*/
614: CURSOR c_get_balance_feeds(c_input_value_id pay_input_values_f.input_value_id%TYPE)
615: IS
616: SELECT balance_type_id, scale
617: FROM pay_balance_feeds_f
618: WHERE input_value_id = c_input_value_id
619: AND business_group_id = p_business_group_id;
620:
621: /* Checks whether balance feed exist for element created by upgrade process */

Line 622: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type

618: WHERE input_value_id = c_input_value_id
619: AND business_group_id = p_business_group_id;
620:
621: /* Checks whether balance feed exist for element created by upgrade process */
622: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
623: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
624: is
625: select count(*)
626: from pay_balance_feeds_f

Line 623: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)

619: AND business_group_id = p_business_group_id;
620:
621: /* Checks whether balance feed exist for element created by upgrade process */
622: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
623: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
624: is
625: select count(*)
626: from pay_balance_feeds_f
627: where balance_type_id = c_balance_type_id

Line 626: from pay_balance_feeds_f

622: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
623: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
624: is
625: select count(*)
626: from pay_balance_feeds_f
627: where balance_type_id = c_balance_type_id
628: and input_value_id = c_input_value_id;
629:
630: /* Gets the input value id of Element created by Upgrade Process*/

Line 1525: FROM pay_balance_feeds_f pbf,

1521: WHERE etei.element_type_id = pet.element_type_id
1522: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1523: AND NOT EXISTS
1524: ( SELECT '1'
1525: FROM pay_balance_feeds_f pbf,
1526: pay_balance_types pbt,
1527: pay_input_values_f pivf
1528: WHERE pbt.balance_type_id = pbf.balance_type_id
1529: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',