APPS.IGS_FI_GEN_005 dependencies on IGS_PE_PERSID_GROUP

Line 1001: FUNCTION finp_get_prsid_grp_code(p_n_group_id igs_pe_persid_group.group_id%TYPE)

997: RETURN NULL;
998: END IF;
999: END finp_get_acct_meth;
1000:
1001: FUNCTION finp_get_prsid_grp_code(p_n_group_id igs_pe_persid_group.group_id%TYPE)
1002: RETURN VARCHAR2 AS
1003: ------------------------------------------------------------------
1004: --Created by : Sanil Madathil, Oracle IDC
1005: --Date created: 03 jan 2003

Line 1018: CURSOR c_igs_pe_prsid_group (cp_n_group_id igs_pe_persid_group.group_id%TYPE) IS

1014: --Change History:
1015: --Who When What
1016: ------------------------------------------------------------------
1017:
1018: CURSOR c_igs_pe_prsid_group (cp_n_group_id igs_pe_persid_group.group_id%TYPE) IS
1019: SELECT group_cd
1020: FROM igs_pe_persid_group
1021: WHERE group_id = cp_n_group_id;
1022:

Line 1020: FROM igs_pe_persid_group

1016: ------------------------------------------------------------------
1017:
1018: CURSOR c_igs_pe_prsid_group (cp_n_group_id igs_pe_persid_group.group_id%TYPE) IS
1019: SELECT group_cd
1020: FROM igs_pe_persid_group
1021: WHERE group_id = cp_n_group_id;
1022:
1023: l_c_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;
1024:

Line 1023: l_c_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;

1019: SELECT group_cd
1020: FROM igs_pe_persid_group
1021: WHERE group_id = cp_n_group_id;
1022:
1023: l_c_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;
1024:
1025: BEGIN
1026:
1027: -- if person group id passed is NULL, the function returns null value