APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on CE_SECURITY_PROFILES_V

Line 1562: FROM ce_security_profiles_v;

1558: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Init_Security';
1559:
1560: CURSOR l_ce_spgt_csr IS
1561: SELECT organization_type, organization_id, name
1562: FROM ce_security_profiles_v;
1563:
1564: BEGIN
1565:
1566: IF ce_sp_access_C = 0 THEN

Line 1628: FROM ce_security_profiles_v

1624: AND po.object_type = 'PAYMENT_INSTRUCTION';
1625:
1626: CURSOR l_validate_org_accessible_csr (p_org_type IN VARCHAR2, p_org_id IN NUMBER) IS
1627: SELECT 'exist'
1628: FROM ce_security_profiles_v
1629: WHERE organization_type = p_org_type
1630: AND organization_id = p_org_id;
1631:
1632: BEGIN

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

1675: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.val_pmt_reg_instr_accessible';
1676:
1677: CURSOR l_accessible_orgs_csr (p_payment_instruction_id IN NUMBER) IS
1678: SELECT count(po.org_id)
1679: FROM iby_pay_instructions_all ins, iby_process_orgs po, ce_security_profiles_v ce_sp
1680: WHERE ins.payment_instruction_id = p_payment_instruction_id
1681: AND ins.payment_instruction_id = po.object_id
1682: AND po.object_type = 'PAYMENT_INSTRUCTION'
1683: AND ce_sp.organization_type = po.org_type

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