[Home] [Help]
840: pac.CONTEXT_ID,
841: pac.CONTEXT_VALUE,
842: null,
843: null))
844: FROM pay_action_contexts pac,
845: pay_assignment_actions pas,
846: pay_payroll_actions ppa
847: WHERE substr(pac.Context_Value,1,4) = p_context_value
848: AND pac.assignment_id in (select papf.assignment_id
1286: , per_time_periods BPTP
1287: , pay_run_results PROCESS_RR
1288: , pay_run_result_values PROCESS
1289: , pay_input_values_f PROCESS_IV
1290: , pay_action_contexts ACX_PROCESS_ID
1291: , ff_contexts CON_PROCESS_ID
1292: where BAL_ASSACT.assignment_action_id = p_source_id
1293: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1294: and FEED.balance_type_id +0 = p_balance_type_id
1340: -- payroll runs having prsi contribution class as A
1341: -- in the same tax year for which the archive is run
1342: /*CURSOR Cur_Act_Contexts IS
1343: SELECT pac.Context_ID,pac.Context_Value,pac.Assignment_action_id
1344: FROM pay_action_contexts pac,pay_assignment_actions pas,
1345: pay_payroll_actions ppa,pay_payroll_actions appa
1346: WHERE pac.Context_Value = 'IE_A'
1347: AND pac.assignment_id = p_assignment_id
1348: AND pas.assignment_action_id = pac.assignment_action_id
1349: AND ppa.payroll_action_id = pas.payroll_action_id
1350: And appa.payroll_action_id = g_archive_pact
1351: AND to_char(appa.date_earned,'YYYY') = to_char(ppa.date_earned,'YYYY')
1352: AND pac.assignment_action_id = (SELECT MAX(assignment_action_id)
1353: FROM pay_action_contexts
1354: WHERE Context_Value = 'IE_A'
1355: AND assignment_id = p_assignment_id);
1356: v_Cur_Act_Contexts Cur_Act_Contexts%ROWTYPE;*/
1357: --Bug 3079945 Start
1398: pac.CONTEXT_ID,
1399: pac.CONTEXT_VALUE,
1400: null,
1401: null))
1402: FROM pay_action_contexts pac,
1403: pay_assignment_actions pas,
1404: pay_payroll_actions ppa
1405: WHERE pac.Context_Value like 'IE_A%'
1406: AND pac.assignment_id in (select papf.assignment_id