DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_CONTEXTS

Line 2205: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)

2201: , pay_payroll_actions ppa
2202: WHERE paa.assignment_action_id = c_assignment_action_id
2203: AND ppa.payroll_action_id = paa.payroll_action_id ;
2204:
2205: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)
2206: IS
2207: SELECT fc.context_id
2208: FROM ff_contexts fc
2209: WHERE fc.context_name = c_context_name;

Line 2208: FROM ff_contexts fc

2204:
2205: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)
2206: IS
2207: SELECT fc.context_id
2208: FROM ff_contexts fc
2209: WHERE fc.context_name = c_context_name;
2210:
2211: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
2212: ,c_context_id ff_contexts.context_id%TYPE)

Line 2212: ,c_context_id ff_contexts.context_id%TYPE)

2208: FROM ff_contexts fc
2209: WHERE fc.context_name = c_context_name;
2210:
2211: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
2212: ,c_context_id ff_contexts.context_id%TYPE)
2213: IS
2214: SELECT COUNT(*)
2215: FROM ff_archive_items fai,
2216: ff_user_entities fue,

Line 2246: l_context_id ff_contexts.context_id%TYPE;

2242: l_eit_value VARCHAR2(10);
2243:
2244: l_new_count NUMBER;
2245: l_old_count NUMBER;
2246: l_context_id ff_contexts.context_id%TYPE;
2247:
2248: BEGIN
2249: g_debug := hr_utility.debug_enabled;
2250: