APPS.IGS_FI_PRC_BALANCES dependencies on IGS_FI_PERSON_HOLDS

Line 1304: FROM igs_fi_person_holds a,

1300:
1301: -- to obtain the process start date for conversion
1302: CURSOR c_get_process_dt IS
1303: SELECT a.process_start_dt
1304: FROM igs_fi_person_holds a,
1305: igs_pe_pers_encumb b,
1306: igs_fi_hold_plan c
1307: WHERE a.hold_plan_name = c.hold_plan_name
1308: AND c.hold_plan_level = 'S'

Line 1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;

1325: FROM igs_fi_balance_rules
1326: WHERE balance_rule_id = cp_balance_rule_id;
1327:
1328: l_rec_get_balances c_get_balances%ROWTYPE;
1329: l_process_start_dt igs_fi_person_holds.process_start_dt%TYPE;
1330: l_conv_process_run_ind igs_fi_control_all.conv_process_run_ind%TYPE;
1331: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1332: l_version_number igs_fi_balance_rules.version_number%TYPE;
1333: l_last_conv_dt igs_fi_balance_rules.last_conversion_date%TYPE;