APPS.PAY_BALANCE_PKG dependencies on FF_ROUTE_CONTEXT_USAGES

Line 689: ff_route_context_usages frcu,

685: --
686: cursor get_bal_contexts (p_def_bal_id in number) is
687: select context_name
688: from ff_contexts fc,
689: ff_route_context_usages frcu,
690: pay_balance_dimensions pbd,
691: pay_defined_balances pdb
692: where pdb.defined_balance_id = p_def_bal_id
693: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 914: from ff_route_context_usages frc

910: is
911: --
912: cursor csr_context_usages is
913: select 'Y'
914: from ff_route_context_usages frc
915: where frc.route_id = p_route_id
916: and frc.context_id = p_context_id;
917: --
918: l_temp varchar2(1);

Line 1252: from ff_route_context_usages

1248: cursor ro_context (p_route_id number)
1249: is
1250: select context_id,
1251: sequence_no
1252: from ff_route_context_usages
1253: where route_id = p_route_id
1254: order by sequence_no;
1255: --
1256: -- Used to retrieve the where clause fillers for the route

Line 1878: from ff_route_context_usages

1874: cursor ro_context (p_route_id number)
1875: is
1876: select context_id,
1877: sequence_no
1878: from ff_route_context_usages
1879: where route_id = p_route_id
1880: order by sequence_no;
1881: --
1882: sql_cursor integer;

Line 2136: from ff_route_context_usages

2132: cursor ro_context (p_route_id number)
2133: is
2134: select context_id,
2135: sequence_no
2136: from ff_route_context_usages
2137: where route_id = p_route_id
2138: order by sequence_no;
2139: --
2140: --

Line 2355: from ff_route_context_usages

2351: cursor ro_context (p_route_id number)
2352: is
2353: select context_id,
2354: sequence_no
2355: from ff_route_context_usages
2356: where route_id = p_route_id
2357: order by sequence_no;
2358: --
2359: -- Used to retrieve the where clause fillers for the route