APPS.IGF_AW_COA_GEN dependencies on IGS_PS_VER

Line 1287: igs_ps_ver ps

1283: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1284: ) IS
1285: SELECT ps.responsible_org_unit_cd,1 record_order
1286: FROM igs_en_spa_terms key,
1287: igs_ps_ver ps
1288: WHERE key.key_program_flag = 'Y'
1289: AND person_id = cp_person_id
1290: AND ps.course_cd = key.program_cd
1291: AND ps.version_number = key.program_version

Line 1298: igs_ps_ver ps

1294: UNION ALL
1295: SELECT ps.responsible_org_unit_cd,
1296: 2 record_order
1297: FROM igs_en_stdnt_ps_att att,
1298: igs_ps_ver ps
1299: WHERE att.person_id = cp_person_id
1300: AND att.key_program = 'Y'
1301: AND att.course_cd = ps.course_cd
1302: AND att.version_number = ps.version_number

Line 1313: igs_ps_ver pv,

1309: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
1310: ) IS
1311: SELECT pt.course_type,1 record_order
1312: FROM igs_en_spa_terms sp,
1313: igs_ps_ver pv,
1314: igs_ps_type_v pt
1315: WHERE sp.key_program_flag = 'Y'
1316: AND sp.program_cd = pv.course_cd
1317: AND sp.program_version = pv.version_number

Line 1325: igs_ps_ver pv,

1321: AND sp.term_sequence_number = cp_ld_sequence_number
1322: UNION ALL
1323: SELECT pt.course_type,2 record_order
1324: FROM igs_en_stdnt_ps_att sp,
1325: igs_ps_ver pv,
1326: igs_ps_type_v pt
1327: WHERE sp.key_program = 'Y'
1328: AND sp.course_cd = pv.course_cd
1329: AND sp.version_number = pv.version_number

Line 1833: p_program_code igs_ps_ver.course_cd%TYPE,

1829:
1830: PROCEDURE ins_coa_todo(
1831: p_person_id hz_parties.party_id%TYPE,
1832: p_calling_module VARCHAR2,
1833: p_program_code igs_ps_ver.course_cd%TYPE,
1834: p_version_number igs_ps_ver.version_number%TYPE
1835: ) AS
1836: ------------------------------------------------------------------
1837: --Created by : veramach, Oracle India

Line 1834: p_version_number igs_ps_ver.version_number%TYPE

1830: PROCEDURE ins_coa_todo(
1831: p_person_id hz_parties.party_id%TYPE,
1832: p_calling_module VARCHAR2,
1833: p_program_code igs_ps_ver.course_cd%TYPE,
1834: p_version_number igs_ps_ver.version_number%TYPE
1835: ) AS
1836: ------------------------------------------------------------------
1837: --Created by : veramach, Oracle India
1838: --Date created: 07-OCT-2004

Line 1881: cp_program_code igs_ps_ver.course_cd%TYPE,

1877: l_seqnum igs_pe_std_todo.sequence_number%TYPE;
1878:
1879: -- Get persons with specified key program
1880: CURSOR c_persons(
1881: cp_program_code igs_ps_ver.course_cd%TYPE,
1882: cp_version_number igs_ps_ver.version_number%TYPE
1883: ) IS
1884: SELECT person_id
1885: FROM igs_en_spa_terms

Line 1882: cp_version_number igs_ps_ver.version_number%TYPE

1878:
1879: -- Get persons with specified key program
1880: CURSOR c_persons(
1881: cp_program_code igs_ps_ver.course_cd%TYPE,
1882: cp_version_number igs_ps_ver.version_number%TYPE
1883: ) IS
1884: SELECT person_id
1885: FROM igs_en_spa_terms
1886: WHERE key_program_flag = 'Y'

Line 2215: FROM igs_ps_ver

2211: CURSOR c_chk_org (cp_org_unit igf_ap_fa_ant_data.org_unit_cd%TYPE,
2212: cp_program_code igf_ap_fa_ant_data.program_cd%TYPE)
2213: IS
2214: SELECT 'x'
2215: FROM igs_ps_ver
2216: WHERE course_cd = cp_program_code
2217: AND ( responsible_org_unit_cd = cp_org_unit
2218: OR EXISTS (SELECT 'x'
2219: FROM igs_ps_own

Line 2233: FROM igs_ps_ver

2229: CURSOR c_chk_prog (cp_program_code igf_ap_fa_ant_data.program_cd%TYPE,
2230: cp_program_type igf_ap_fa_ant_data.program_type%TYPE)
2231: IS
2232: SELECT 'x'
2233: FROM igs_ps_ver
2234: WHERE course_cd = cp_program_code
2235: AND course_type = cp_program_type;
2236:
2237: l_chk_prog c_chk_prog%ROWTYPE;