APPS.ASO_TAX_INT dependencies on PER_ALL_ASSIGNMENTS_F

Line 790: from per_all_assignments_f

786: --Commented code end yogeshwar (MOAC)
787:
788: cursor c_asgn(c_person_id number) is
789: select organization_id
790: from per_all_assignments_f
791: where person_id = c_person_id
792: and nvl(primary_flag, 'Y') = 'Y'
793: and sysdate between nvl(effective_start_date,to_date( '01011900', 'DDMMYYYY'))
794: and nvl(effective_end_date,to_date( '31122199', 'DDMMYYYY'));

Line 2327: FROM jtf_rs_srp_vl sales, per_all_assignments_f per

2323: WHERE trx.quote_header_id = l_qte_hdr_id;
2324:
2325: Cursor c_get_org_id ( l_source_id NUMBER) is
2326: SELECT per.organization_id
2327: FROM jtf_rs_srp_vl sales, per_all_assignments_f per
2328: WHERE sales.resource_id = l_source_id
2329: AND per.person_id = sales.person_id
2330: AND nvl(per.primary_flag,'Y') = 'Y'
2331: AND sysdate BETWEEN nvl(per.effective_start_date,sysdate) AND nvl(per.effective_end_date,sysdate);