APPS.AR_AGING_BUCKETS_PKG dependencies on AR_CALC_AGING

Line 1132: ar_calc_aging.FLEX_SQL(p_application_id => 101,

1128: IF pg_in_bal_segment_low IS NULL AND pg_in_bal_segment_high IS NULL THEN
1129: pg_bal_seg_where := NULL;
1130: ELSIF pg_in_bal_segment_low IS NULL THEN
1131: pg_bal_seg_where := ' AND ' ||
1132: ar_calc_aging.FLEX_SQL(p_application_id => 101,
1133: p_id_flex_code => 'GL#',
1134: p_id_flex_num =>pg_coaid,
1135: p_table_alias => 'GC',
1136: p_mode => 'WHERE',

Line 1142: ar_calc_aging.FLEX_SQL(p_application_id => 101,

1138: p_function => '<=',
1139: p_operand1 => pg_in_bal_segment_high);
1140: ELSIF pg_in_bal_segment_high IS NULL THEN
1141: pg_bal_seg_where := ' AND ' ||
1142: ar_calc_aging.FLEX_SQL(p_application_id => 101,
1143: p_id_flex_code => 'GL#',
1144: p_id_flex_num => pg_coaid,
1145: p_table_alias => 'GC',
1146: p_mode => 'WHERE',

Line 1152: ar_calc_aging.FLEX_SQL(p_application_id => 101,

1148: p_function => '>=',
1149: p_operand1 => pg_in_bal_segment_low);
1150: ELSE
1151: pg_bal_seg_where := ' AND ' ||
1152: ar_calc_aging.FLEX_SQL(p_application_id => 101,
1153: p_id_flex_code => 'GL#',
1154: p_id_flex_num =>pg_coaid,
1155: p_table_alias => 'GC',
1156: p_mode => 'WHERE',

Line 1164: ar_calc_aging.FLEX_SQL(p_application_id => 101,

1160: p_operand2 => pg_in_bal_segment_high);
1161: END IF;
1162:
1163: pg_accounting_flexfield :=
1164: ar_calc_aging.FLEX_SQL(p_application_id => 101,
1165: p_id_flex_code => 'GL#',
1166: p_id_flex_num =>pg_coaid,
1167: p_table_alias => 'c',
1168: p_mode => 'SELECT',

Line 1172: ar_calc_aging.FLEX_SQL(p_application_id => 101,

1168: p_mode => 'SELECT',
1169: p_qualifier => 'ALL');
1170:
1171: pg_acct_flex_bal_seg :=
1172: ar_calc_aging.FLEX_SQL(p_application_id => 101,
1173: p_id_flex_code => 'GL#',
1174: p_id_flex_num =>pg_coaid,
1175: p_table_alias => 'c',
1176: p_mode => 'SELECT',