DBA Data[Home] [Help]

APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PAY_BALANCE_FEEDS_F

Line 1975: from pay_balance_feeds_f pbf,

1971: /* cursor used to archive the footnote code values */
1972: cursor c_balance_feed_info (p_balance_name varchar2) is
1973: select distinct pet.element_information18,
1974: pbt1.balance_name
1975: from pay_balance_feeds_f pbf,
1976: pay_balance_types pbt,
1977: pay_balance_types pbt1,
1978: pay_input_values_f piv,
1979: pay_element_types_f pet,

Line 1997: from pay_balance_feeds_f pbf,

1993: cursor c_reg_balance_feed_info (p_balance_name varchar2) is
1994: select distinct nvl(pet.element_information20,'NOT FOUND'),
1995: pbt1.balance_name,pet.element_type_id,
1996: pet.classification_id
1997: from pay_balance_feeds_f pbf,
1998: pay_balance_types pbt,
1999: pay_balance_types pbt1,
2000: pay_input_values_f piv,
2001: pay_element_types_f pet

Line 3388: from pay_balance_feeds_f pbf,

3384: /* cursor used to archive the footnote code values */
3385: cursor c_balance_feed_info (p_balance_name varchar2) is
3386: select distinct pet.element_information18,
3387: pbt1.balance_name
3388: from pay_balance_feeds_f pbf,
3389: pay_balance_types pbt,
3390: pay_balance_types pbt1,
3391: pay_input_values_f piv,
3392: pay_element_types_f pet,

Line 3410: from pay_balance_feeds_f pbf,

3406: cursor c_reg_balance_feed_info (p_balance_name varchar2) is
3407: select distinct nvl(pet.element_information20,'NOT FOUND'),
3408: pbt1.balance_name,pet.element_type_id,
3409: pet.classification_id
3410: from pay_balance_feeds_f pbf,
3411: pay_balance_types pbt,
3412: pay_balance_types pbt1,
3413: pay_input_values_f piv,
3414: pay_element_types_f pet