DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_OR_UNIT

Line 2102: --sommukhe 08-JAN-2006 Bug#3305881,modified cursor c_ou by replacing IGS_OR_UNIT with IGS_OR_INST_ORG_BASE_V

2098: AS
2099: -------------------------------------------------------------------------------------------------------------------
2100: --Change History:
2101: --Who When What
2102: --sommukhe 08-JAN-2006 Bug#3305881,modified cursor c_ou by replacing IGS_OR_UNIT with IGS_OR_INST_ORG_BASE_V
2103: --sarakshi 12-Jan-2006 BUg#4926548,modified cursor c_fee_type_exists and c_fee_type_cal_exists to address performance issues, created pl-sql table.
2104: --sommukhe 23-NOV-2005 Bug#4726560, added cursors cur_usec_tchr_lead,cur_usec_tchr1, c_tch_ins and cur_usec_gs_df.
2105: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging
2106: --sarakshi 12-Sep-2005 Bug#45772, placed flexfield attributes in the call to the occurrence insert row with the local variables.

Line 3897: CURSOR c_ou( cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,

3893: AND ROWNUM = 1;
3894: l_cur_usec_tro_new cur_usec_tro_new%ROWTYPE;
3895:
3896:
3897: CURSOR c_ou( cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
3898: cp_start_dt igs_or_unit.start_dt%TYPE) IS
3899: SELECT 'x'
3900: FROM igs_or_inst_org_base_v ou,
3901: igs_or_status os

Line 3898: cp_start_dt igs_or_unit.start_dt%TYPE) IS

3894: l_cur_usec_tro_new cur_usec_tro_new%ROWTYPE;
3895:
3896:
3897: CURSOR c_ou( cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
3898: cp_start_dt igs_or_unit.start_dt%TYPE) IS
3899: SELECT 'x'
3900: FROM igs_or_inst_org_base_v ou,
3901: igs_or_status os
3902: WHERE ou.party_number = cp_org_unit_cd