[Home] [Help]
397: WHERE paf1.assignment_id = paf.assignment_id
398: AND paf1.effective_start_date <= p_effective_dt)
399: AND not exists
400: ( SELECT pail.locked_action_id
401: FROM pay_action_interlocks pail,
402: pay_payroll_actions pact,
403: pay_assignment_actions passt
404: WHERE pact.report_type = 'RL2_AMEND_MAG'
405: AND pact.payroll_action_id = passt.payroll_action_id
406: AND passt.assignment_action_id = pail.locking_action_id
407: AND pail.locked_action_id = paa_arch.assignment_action_id)
408: AND not exists
409: ( SELECT pail.locked_action_id
410: FROM pay_action_interlocks pail,
411: pay_payroll_actions pact,
412: pay_assignment_actions passt
413: WHERE pact.report_type = 'RL2_XML_MAG'
414: AND pact.payroll_action_id = passt.payroll_action_id
415: AND passt.assignment_action_id = pail.locking_action_id
416: AND pail.locked_action_id = paa_arch.assignment_action_id)
417: AND not exists
418: ( SELECT pail.locked_action_id
419: FROM pay_action_interlocks pail,
420: pay_payroll_actions pact,
421: pay_assignment_actions passt
422: WHERE pact.report_type = 'CAEOY_RL2_AMEND_PP'
423: AND pact.payroll_action_id = passt.payroll_action_id
456: and paf.effective_start_date <= cp_effective_date
457: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
458: AND not exists
459: ( SELECT pail.locked_action_id
460: FROM pay_action_interlocks pail,
461: pay_payroll_actions pact,
462: pay_assignment_actions passt
463: WHERE pact.report_type = 'RL2_AMEND_MAG'
464: AND pact.payroll_action_id = passt.payroll_action_id
1364: paa.assignment_id,
1365: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
1366: -- date_earned
1367: FROM
1368: pay_action_interlocks pai,
1369: pay_assignment_actions paa,
1370: pay_payroll_actions ppa,
1371: per_all_people_f ppf,
1372: per_all_assignments_f paf,