APPS.PAY_BALANCE_PKG dependencies on FF_ROUTE_CONTEXT_USAGES

Line 34: (context_id ff_route_context_usages.context_id%type,

30: );
31: route_contexts_cache route_contexts_cache_type;
32:
33: type t_route_context_usage is record
34: (context_id ff_route_context_usages.context_id%type,
35: sequence_no ff_route_context_usages.sequence_no%type,
36: context_name ff_contexts.context_name%type
37: );
38: type t_route_context_usage_tab is table of t_route_context_usage index by binary_integer;

Line 35: sequence_no ff_route_context_usages.sequence_no%type,

31: route_contexts_cache route_contexts_cache_type;
32:
33: type t_route_context_usage is record
34: (context_id ff_route_context_usages.context_id%type,
35: sequence_no ff_route_context_usages.sequence_no%type,
36: context_name ff_contexts.context_name%type
37: );
38: type t_route_context_usage_tab is table of t_route_context_usage index by binary_integer;
39: --

Line 779: ff_route_context_usages frcu,

775: --
776: cursor get_bal_contexts (p_def_bal_id in number) is
777: select context_name
778: from ff_contexts fc,
779: ff_route_context_usages frcu,
780: pay_balance_dimensions pbd,
781: pay_defined_balances pdb
782: where pdb.defined_balance_id = p_def_bal_id
783: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1001: from ff_route_context_usages frc

997: is
998: --
999: cursor csr_context_usages is
1000: select 'Y'
1001: from ff_route_context_usages frc
1002: where frc.route_id = p_route_id
1003: and frc.context_id = p_context_id;
1004: --
1005: l_temp varchar2(1);

Line 1339: from ff_route_context_usages

1335: cursor ro_context (p_route_id number)
1336: is
1337: select context_id,
1338: sequence_no
1339: from ff_route_context_usages
1340: where route_id = p_route_id
1341: order by sequence_no;
1342: --
1343: -- Used to retrieve the where clause fillers for the route

Line 1968: from ff_route_context_usages rcu, ff_contexts c

1964: is
1965: select rcu.context_id,
1966: rcu.sequence_no,
1967: c.context_name
1968: from ff_route_context_usages rcu, ff_contexts c
1969: where rcu.route_id = p_route_id
1970: and c.context_id = rcu.context_id
1971: order by rcu.sequence_no;
1972: --

Line 2303: from ff_route_context_usages

2299: cursor ro_context (p_route_id number)
2300: is
2301: select context_id,
2302: sequence_no
2303: from ff_route_context_usages
2304: where route_id = p_route_id
2305: order by sequence_no;
2306: --
2307: --

Line 2523: from ff_route_context_usages rcu,

2519: is
2520: select rcu.context_id,
2521: rcu.sequence_no,
2522: c.context_name
2523: from ff_route_context_usages rcu,
2524: ff_contexts c
2525: where rcu.route_id = p_route_id
2526: and c.context_id = rcu.context_id
2527: order by sequence_no;