APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on CE_SECURITY_PROFILES_V

Line 1771: FROM ce_security_profiles_v;

1767: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Init_Security';
1768:
1769: CURSOR l_ce_spgt_csr IS
1770: SELECT organization_type, organization_id, name
1771: FROM ce_security_profiles_v;
1772:
1773: BEGIN
1774:
1775: IF ce_sp_access_C = 0 THEN

Line 1837: FROM ce_security_profiles_v

1833: AND po.object_type = 'PAYMENT_INSTRUCTION';
1834:
1835: CURSOR l_validate_org_accessible_csr (p_org_type IN VARCHAR2, p_org_id IN NUMBER) IS
1836: SELECT 'exist'
1837: FROM ce_security_profiles_v
1838: WHERE organization_type = p_org_type
1839: AND organization_id = p_org_id;
1840:
1841: BEGIN

Line 1888: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp

1884: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.val_pmt_reg_instr_accessible';
1885:
1886: CURSOR l_accessible_orgs_csr (p_payment_instruction_id IN NUMBER) IS
1887: SELECT count(po.org_id)
1888: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp
1889: WHERE ins.payment_instruction_id = p_payment_instruction_id
1890: AND ins.payment_instruction_id = po.object_id
1891: AND po.object_type = 'PAYMENT_INSTRUCTION'
1892: AND ce_sp.organization_type = po.org_type

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