APPS.PAY_CORE_UPGRADE_PKG dependencies on FF_CONTEXTS

Line 49: type t_cont_nm is table of ff_contexts.context_name%type

45: type t_tg is table of pay_latest_balances.tax_group%type
46: index by binary_integer;
47: type t_pay_id is table of pay_latest_balances.payroll_id%type
48: index by binary_integer;
49: type t_cont_nm is table of ff_contexts.context_name%type
50: index by binary_integer;
51: type t_cont_vl is table of pay_balance_context_values.value%type
52: index by binary_integer;
53: --

Line 96: ff_contexts fc

92: is
93: select fc.context_name,
94: pbcv.value
95: from pay_balance_context_values pbcv,
96: ff_contexts fc
97: where pbcv.latest_balance_id = p_latest_bal_id
98: and pbcv.context_id = fc.context_id;
99: --
100: cursor c_get_asgs (p_person_id in number)

Line 166: ff_contexts fc

162: l_cont_value,
163: l_cont_name
164: from pay_person_latest_balances pplb,
165: pay_balance_context_values pbcv,
166: ff_contexts fc
167: where pplb.person_id = p_person_id
168: and pplb.latest_balance_id = pbcv.latest_balance_id (+)
169: and nvl(pbcv.context_id, -1) = fc.context_id (+)
170: order by pplb.latest_balance_id;

Line 325: ff_contexts fc

321: l_cont_value,
322: l_cont_name
323: from pay_assignment_latest_balances palb,
324: pay_balance_context_values pbcv,
325: ff_contexts fc
326: where palb.assignment_id = asgrec.assignment_id
327: and palb.latest_balance_id = pbcv.latest_balance_id (+)
328: and nvl(pbcv.context_id, -1) = fc.context_id (+)
329: order by palb.latest_balance_id;