APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_BALANCE_FEEDS_F

Line 764: FROM pay_balance_feeds_f

760: /* Gets the balance feeds attached with the input value of retro element*/
761: CURSOR c_get_balance_feeds(c_input_value_id pay_input_values_f.input_value_id%TYPE)
762: IS
763: SELECT balance_type_id, scale
764: FROM pay_balance_feeds_f
765: WHERE input_value_id = c_input_value_id
766: AND business_group_id = p_business_group_id;
767:
768: /* Checks whether balance feed exist for element created by upgrade process */

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

765: WHERE input_value_id = c_input_value_id
766: AND business_group_id = p_business_group_id;
767:
768: /* Checks whether balance feed exist for element created by upgrade process */
769: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
770: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
771: is
772: select count(*)
773: from pay_balance_feeds_f

Line 770: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)

766: AND business_group_id = p_business_group_id;
767:
768: /* Checks whether balance feed exist for element created by upgrade process */
769: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
770: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
771: is
772: select count(*)
773: from pay_balance_feeds_f
774: where balance_type_id = c_balance_type_id

Line 773: from pay_balance_feeds_f

769: cursor check_feed_exists(c_balance_type_id pay_balance_feeds_f.balance_type_id%type
770: ,c_input_value_id pay_balance_feeds_f.input_value_id%type)
771: is
772: select count(*)
773: from pay_balance_feeds_f
774: where balance_type_id = c_balance_type_id
775: and input_value_id = c_input_value_id;
776:
777: /* Gets the input value id of Element created by Upgrade Process*/

Line 1728: FROM pay_balance_feeds_f pbf,

1724: WHERE etei.element_type_id = pet.element_type_id
1725: AND etei.information_type = 'AU_RETRO_UPGRADE_INFO')
1726: AND NOT EXISTS
1727: ( SELECT '1'
1728: FROM pay_balance_feeds_f pbf,
1729: pay_balance_types pbt,
1730: pay_input_values_f pivf
1731: WHERE pbt.balance_type_id = pbf.balance_type_id
1732: AND pbt.balance_name in ('Retro LT 12 Mths Curr Yr Amount',