DBA Data[Home] [Help]

APPS.IGF_AP_CALC_IM_EFC dependencies on IGS_PE_PERSID_GROUP_ALL

Line 38: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE

34: PROCEDURE log_parameters(
35: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
36: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
39: ) AS
40: ------------------------------------------------------------------
41: --Created by : veramach, Oracle India
42: --Date created: 08-OCT-2003

Line 72: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE

68: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
69:
70: -- Get get group description for group_id
71: CURSOR c_person_group(
72: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
73: ) IS
74: SELECT group_cd group_name
75: FROM igs_pe_persid_group_all
76: WHERE group_id = cp_persid_grp;

Line 75: FROM igs_pe_persid_group_all

71: CURSOR c_person_group(
72: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE
73: ) IS
74: SELECT group_cd group_name
75: FROM igs_pe_persid_group_all
76: WHERE group_id = cp_persid_grp;
77:
78: l_persid_grp_name c_person_group%ROWTYPE;
79:

Line 1042: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE

1038: errbuf OUT NOCOPY VARCHAR2,
1039: retcode OUT NOCOPY NUMBER,
1040: p_award_year IN VARCHAR2,
1041: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1042: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE
1043: ) AS
1044: ------------------------------------------------------------------
1045: --Created by : veramach, Oracle India
1046: --Date created: 08-OCT-2003