APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_ASSIGNMENT_ACTIONS

Line 336: ,pay_assignment_actions paa

332: CURSOR c_date_earned
333: IS
334: SELECT NVL(ppa.date_earned,ppa.effective_date)
335: FROM pay_payroll_actions ppa
336: ,pay_assignment_actions paa
337: ,pay_action_interlocks pai
338: WHERE pai.locking_action_id = p_assignment_action_id
339: AND pai.locked_action_id = paa.assignment_action_id
340: AND paa.payroll_action_id = ppa.payroll_action_Id

Line 402: ,pay_assignment_actions pre_paa

398: )
399: IS
400: SELECT assignment_action_id
401: FROM pay_payroll_actions pre_ppa
402: ,pay_assignment_actions pre_paa
403: WHERE pre_ppa.payroll_action_id = pre_paa.payroll_action_id
404: AND pre_paa.assignment_id = p_assignment_id
405: AND pre_ppa.action_type IN ('P','U')
406: AND pre_ppa.action_status = 'C'

Line 419: ,pay_assignment_actions pre_paa

415: )
416: IS
417: SELECT assignment_action_id
418: FROM pay_payroll_actions pre_ppa
419: ,pay_assignment_actions pre_paa
420: WHERE pre_ppa.payroll_action_id = pre_paa.payroll_action_id
421: AND pre_paa.assignment_id = p_assignment_id
422: AND pre_ppa.action_type IN ('P','U')
423: AND pre_ppa.action_status = 'C'

Line 437: ,pay_assignment_actions pre_paa

433: )
434: IS
435: SELECT assignment_action_id
436: FROM pay_payroll_actions pre_ppa
437: ,pay_assignment_actions pre_paa
438: WHERE pre_ppa.payroll_action_id = pre_paa.payroll_action_id
439: AND pre_paa.assignment_id = p_assignment_id
440: AND pre_ppa.action_type IN ('P','U')
441: AND pre_ppa.action_status = 'C'

Line 454: ,pay_assignment_actions paa

450: )
451: IS
452: SELECT NVL(date_earned,effective_date)
453: FROM pay_payroll_actions ppa
454: ,pay_assignment_actions paa
455: ,pay_action_interlocks pai
456: WHERE ppa.payroll_action_id = paa.payroll_action_id
457: AND paa.assignment_id = p_assignment_id
458: AND ppa.action_type IN ('Q','R','A')

Line 574: ,pay_assignment_actions paa

570: CURSOR c_action_type
571: IS
572: SELECT ppa.action_type
573: FROM pay_payroll_actions ppa
574: ,pay_assignment_actions paa
575: WHERE ppa.payroll_action_id = paa.payroll_action_id
576: AND paa.assignment_action_id = p_assignment_action_id
577: AND ppa.action_status = 'C';
578:

Line 584: ,pay_assignment_actions paa

580: IS
581: SELECT pai.locked_action_id assignment_action_id
582: ,paa.assignment_id
583: FROM pay_action_interlocks pai
584: ,pay_assignment_actions paa
585: WHERE pai.locking_action_id = p_assignment_action_id
586: AND pai.locked_action_id = paa.assignment_action_id
587: AND paa.action_status = 'C'
588: AND paa.source_action_id IS NULL

Line 596: FROM pay_assignment_actions

592: ,p_master_asg_act_id NUMBER
593: )
594: IS
595: SELECT assignment_action_id child_actions
596: FROM pay_assignment_actions
597: WHERE assignment_id = p_assignment_id
598: AND action_status = 'C'
599: AND source_action_id = p_master_asg_act_id;
600: