DBA Data[Home] [Help]

APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_ACTION_INTERLOCKS

Line 337: ,pay_action_interlocks pai

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
341: AND ppa.action_type IN ('Q','R','A')

Line 455: ,pay_action_interlocks pai

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')
459: AND ppa.action_status = 'C'

Line 583: FROM pay_action_interlocks pai

579: CURSOR c_master_asg_action_id
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'