APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_PAYROLL_ACTIONS

Line 335: FROM pay_payroll_actions ppa

331:
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

Line 401: FROM pay_payroll_actions pre_ppa

397: ,p_effective_date DATE
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')

Line 418: FROM pay_payroll_actions pre_ppa

414: ,p_ee_payment_date DATE
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')

Line 436: FROM pay_payroll_actions pre_ppa

432: ,p_ee_payment_date DATE
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')

Line 453: FROM pay_payroll_actions ppa

449: ,p_assignment_action_id NUMBER
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

Line 573: FROM pay_payroll_actions ppa

569:
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';

Line 601: l_action_type pay_payroll_actions.action_type%TYPE;

597: WHERE assignment_id = p_assignment_id
598: AND action_status = 'C'
599: AND source_action_id = p_master_asg_act_id;
600:
601: l_action_type pay_payroll_actions.action_type%TYPE;
602: l_assignment_action_id NUMBER;
603: l_balance_value NUMBER;
604: l_procedure VARCHAR2(250);
605: l_message VARCHAR2(250);