DBA Data[Home] [Help]

APPS.PAY_IE_P30LOCK dependencies on FND_NUMBER

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

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