APPS.IGS_FI_GEN_008 dependencies on IGS_FI_BALANCES

Line 1027: FUNCTION get_std_balance(p_partyid IN igs_fi_balances.party_id%TYPE) RETURN NUMBER AS

1023: END IF;
1024:
1025: END get_special_retention_amt;
1026:
1027: FUNCTION get_std_balance(p_partyid IN igs_fi_balances.party_id%TYPE) RETURN NUMBER AS
1028:
1029: /***************************************************************************
1030: || Created By : svuppala
1031: || Created On : 10-Apr-2002

Line 1044: FROM igs_fi_balances

1040:
1041: -- Cursor for fetching the standard balance for the partyid passed as input to the function
1042: CURSOR cur_partyid(cp_partyid NUMBER) IS
1043: SELECT standard_balance
1044: FROM igs_fi_balances
1045: WHERE party_id = cp_partyid
1046: ORDER BY balance_date DESC;
1047:
1048: l_std_balance igs_fi_balances.standard_balance%TYPE;

Line 1048: l_std_balance igs_fi_balances.standard_balance%TYPE;

1044: FROM igs_fi_balances
1045: WHERE party_id = cp_partyid
1046: ORDER BY balance_date DESC;
1047:
1048: l_std_balance igs_fi_balances.standard_balance%TYPE;
1049:
1050: BEGIN
1051:
1052: -- Fetch the standard Balance