DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on FND_NUMBER

Line 493: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))

489: --Bug Fix 4032212 This cursor is added to get the max action_context_id against the P30 Data Lock id
490: -- Changed to fetch correct action context if Archiver is run for Period 2 first and then for period1
491: CURSOR get_action_context (vp_Payroll_Action_Id Pay_Payroll_Actions.Payroll_Action_ID%TYPE,
492: vp_Assignment_Id Pay_Assignment_Actions.Assignment_Action_ID%TYPE) IS
493: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa_run.action_sequence,15,'0')||pact_ytdbal.ACTION_CONTEXT_ID),16))
494: FROM pay_assignment_actions paa_p30,
495: pay_action_interlocks pai_p30,
496: pay_assignment_actions paa_arc,
497: pay_action_information pact_ytdbal,