APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_PROCESS_ORGS

Line 1830: FROM iby_pay_instructions_all ins, iby_process_orgs po

1826:
1827: -- all orgs belonging to the instruction
1828: CURSOR l_ins_org_csr (p_payment_instruction_id IN NUMBER) IS
1829: SELECT po.org_type, po.org_id
1830: FROM iby_pay_instructions_all ins, iby_process_orgs po
1831: WHERE ins.payment_instruction_id = p_payment_instruction_id
1832: AND ins.payment_instruction_id = po.object_id
1833: AND po.object_type = 'PAYMENT_INSTRUCTION';
1834:

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

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: