DBA Data[Home] [Help]

APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PAY_SERVICE_REQUESTS

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

1958: l_num_accessible_orgs NUMBER;
1959:
1960: CURSOR l_accessible_orgs_csr (p_payment_service_request_id IN NUMBER) IS
1961: SELECT count(po.org_id)
1962: FROM iby_pay_service_requests ppr, iby_process_orgs po, ce_security_profiles_v ce_sp
1963: WHERE ppr.payment_service_request_id = p_payment_service_request_id
1964: AND ppr.payment_service_request_id = po.object_id
1965: AND po.object_type = 'PAYMENT_REQUEST'
1966: AND ce_sp.organization_type = po.org_type

Line 1990: FROM iby_pay_service_requests ppr, iby_process_orgs po

1986: l_total_orgs NUMBER;
1987:
1988: CURSOR l_total_orgs_csr (p_payment_service_request_id IN NUMBER) IS
1989: SELECT count(po.org_id)
1990: FROM iby_pay_service_requests ppr, iby_process_orgs po
1991: WHERE ppr.payment_service_request_id = p_payment_service_request_id
1992: AND ppr.payment_service_request_id = po.object_id
1993: AND po.object_type = 'PAYMENT_REQUEST';
1994: