DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_BALANCE_CATEGORIES_F

Line 474: from pay_balance_types pbt, pay_balance_categories_f pbc

470: cursor csr_balance (
471: p_balance_category_name varchar2
472: ) is
473: select pbt.balance_name
474: from pay_balance_types pbt, pay_balance_categories_f pbc
475: where pbc.legislation_code = 'FI'
476: and pbt.balance_category_id = pbc.balance_category_id
477: and pbt.business_group_id = g_business_group_id
478: and pbc.category_name = p_balance_category_name;

Line 1223: from pay_balance_types pbt, pay_balance_categories_f pbc

1219: cursor csr_balance (
1220: p_balance_category_name varchar2
1221: ) is
1222: select pbt.balance_name
1223: from pay_balance_types pbt, pay_balance_categories_f pbc
1224: where pbc.legislation_code = 'FI'
1225: and pbt.balance_category_id = pbc.balance_category_id
1226: and pbt.business_group_id = g_business_group_id
1227: and pbc.category_name = p_balance_category_name;