DBA Data[Home] [Help]

APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAY_SERVICE_REQUESTS

Line 1753: FROM iby_pay_service_requests ppr, iby_process_orgs po, ce_security_profiles_v ce_sp

1749: l_num_accessible_orgs NUMBER;
1750:
1751: CURSOR l_accessible_orgs_csr (p_payment_service_request_id IN NUMBER) IS
1752: SELECT count(po.org_id)
1753: FROM iby_pay_service_requests ppr, iby_process_orgs po, ce_security_profiles_v ce_sp
1754: WHERE ppr.payment_service_request_id = p_payment_service_request_id
1755: AND ppr.payment_service_request_id = po.object_id
1756: AND po.object_type = 'PAYMENT_REQUEST'
1757: AND ce_sp.organization_type = po.org_type

Line 1781: FROM iby_pay_service_requests ppr, iby_process_orgs po

1777: l_total_orgs NUMBER;
1778:
1779: CURSOR l_total_orgs_csr (p_payment_service_request_id IN NUMBER) IS
1780: SELECT count(po.org_id)
1781: FROM iby_pay_service_requests ppr, iby_process_orgs po
1782: WHERE ppr.payment_service_request_id = p_payment_service_request_id
1783: AND ppr.payment_service_request_id = po.object_id
1784: AND po.object_type = 'PAYMENT_REQUEST';
1785: