DBA Data[Home] [Help]

APPS.PYUSDAR_PKG dependencies on PAY_ACTION_INFORMATION

Line 709: from pay_action_information pai

705: /* ONLINE or PRINT ? */
706: and pay_us_employee_payslip_web.get_doc_eit('PAYSLIP','PRINT'
707: ,'ASSIGNMENT',paf.assignment_id,ppa_dar.effective_date) = 'Y'
708: and exists ( select 1
709: from pay_action_information pai
710: where pai.action_context_id = paa_xfr.assignment_action_id
711: and rownum < 2 ) --Bug 3343621
712: order by paf.person_id, paf.assignment_id DESC;
713: -- for update of paf.assignment_id;

Line 817: from pay_action_information pai

813: /* ONLINE or PRINT ? */
814: and pay_us_employee_payslip_web.get_doc_eit('PAYSLIP','PRINT'
815: ,'ASSIGNMENT',paf.assignment_id,ppa_dar.effective_date) = 'Y'
816: and exists ( select 1
817: from pay_action_information pai
818: where pai.action_context_id = paa_xfr.assignment_action_id
819: and pai.action_context_type not in ('AAP')
820: and pai.action_information_category not in ('EMPLOYEE NET PAY DISTRIBUTION')
821: )