DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on FF_CONTEXTS

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

1486: , pay_payroll_actions ppa
1487: WHERE paa.assignment_action_id = c_assignment_action_id
1488: AND ppa.payroll_action_id = paa.payroll_action_id ;
1489:
1490: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)
1491: IS
1492: SELECT fc.context_id
1493: FROM ff_contexts fc
1494: WHERE fc.context_name = c_context_name;

Line 1493: FROM ff_contexts fc

1489:
1490: CURSOR get_context_id(c_context_name ff_contexts.context_name%TYPE)
1491: IS
1492: SELECT fc.context_id
1493: FROM ff_contexts fc
1494: WHERE fc.context_name = c_context_name;
1495:
1496: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
1497: ,c_context_id ff_contexts.context_id%TYPE)

Line 1497: ,c_context_id ff_contexts.context_id%TYPE)

1493: FROM ff_contexts fc
1494: WHERE fc.context_name = c_context_name;
1495:
1496: CURSOR get_archive_item_count(c_archive_action_id pay_assignment_actions.assignment_action_id%TYPE
1497: ,c_context_id ff_contexts.context_id%TYPE)
1498: IS
1499: SELECT COUNT(*)
1500: FROM ff_archive_items fai,
1501: ff_user_entities fue,

Line 1529: l_context_id ff_contexts.context_id%TYPE;

1525: l_eit_value VARCHAR2(10);
1526:
1527: l_new_count NUMBER;
1528: l_old_count NUMBER;
1529: l_context_id ff_contexts.context_id%TYPE;
1530:
1531: BEGIN
1532: g_debug := hr_utility.debug_enabled;
1533: