APPS.FV_1219_TRANSACTIONS dependencies on FV_SF1219_TEMP_S

Line 29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;

25:
26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;

Line 30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;

26: l_fund_code FV_SF1219_TEMP.fund_code%TYPE;
27: l_name FV_SF1219_TEMP.name%TYPE;
28: l_name_keep FV_SF1219_TEMP.name%TYPE;
29: l_set_of_books_id FV_SF1219_TEMP.set_of_books_id%TYPE;
30: l_sf1219_type_code FV_SF1219_TEMP.sf1219_type_code%TYPE;
31: l_reported_month FV_SF1219_TEMP.reported_month%TYPE;
32: l_posted_date FV_SF1219_TEMP.posted_date%TYPE;
33: l_reported_gl_period FV_SF1219_TEMP.reported_gl_period%TYPE;
34: l_amount FV_SF1219_TEMP.amount%TYPE;

Line 570: fv_sf1219_temp_s.NEXTVAL,

566:
567: /* Start for non-sla, upgraded 11i data */
568:
569: l_string2 := 'SELECT
570: fv_sf1219_temp_s.NEXTVAL,
571: glb.je_batch_id,
572: ffp.fund_value,
573: NVL(glb.name,''Manual''),
574: --glb.set_of_books_id,

Line 727: fv_sf1219_temp_s.NEXTVAL,

723:
724: /* Start for je_source is payables and je_category is non treasury */
725:
726: l_string2 := 'SELECT
727: fv_sf1219_temp_s.NEXTVAL,
728: glb.je_batch_id,
729: ffp.fund_value,
730: glb.name,
731: :b_sob,

Line 906: fv_sf1219_temp_s.NEXTVAL,

902:
903: /* Start for je_source is payables and je_category is non treasury */
904:
905: l_string2 := 'SELECT
906: fv_sf1219_temp_s.NEXTVAL,
907: glb.je_batch_id,
908: ffp.fund_value,
909: glb.name,
910: :b_sob,

Line 1086: fv_sf1219_temp_s.NEXTVAL,

1082:
1083: /* Start for je_source is payables and je_category is treasury confirmation */
1084:
1085: l_string2 := 'SELECT
1086: fv_sf1219_temp_s.NEXTVAL,
1087: glb.je_batch_id,
1088: ffp.fund_value,
1089: glb.name,
1090: :b_sob,

Line 1263: fv_sf1219_temp_s.NEXTVAL,

1259: /* Start for je_source is project and je_category is labour_cost */
1260:
1261:
1262: l_string2 := 'SELECT
1263: fv_sf1219_temp_s.NEXTVAL,
1264: glb.je_batch_id,
1265: ffp.fund_value,
1266: glb.name,
1267: :b_sob,

Line 1439: fv_sf1219_temp_s.NEXTVAL,

1435:
1436: /* Start for je_source is Receivables, based on ar_cash_receipt_history_all */
1437:
1438: l_string2 := 'SELECT
1439: fv_sf1219_temp_s.NEXTVAL,
1440: glb.je_batch_id,
1441: ffp.fund_value,
1442: glb.name,
1443: :b_sob,

Line 1620: fv_sf1219_temp_s.NEXTVAL,

1616: /* Start for je_source is Receivables, based on AR_RECEIVABLE_APPLICATIONS_ALL*/
1617:
1618:
1619: l_string2 := 'SELECT
1620: fv_sf1219_temp_s.NEXTVAL,
1621: glb.je_batch_id,
1622: ffp.fund_value,
1623: glb.name,
1624: :b_sob,

Line 1800: fv_sf1219_temp_s.NEXTVAL,

1796:
1797: /* Start for je_source is Receivables, based on AR_MISC_CASH_DISTRIBUTIONS_ALL */
1798:
1799: l_string2 := 'SELECT
1800: fv_sf1219_temp_s.NEXTVAL,
1801: glb.je_batch_id,
1802: ffp.fund_value,
1803: glb.name,
1804: :b_sob,

Line 2060: fv_sf1219_temp_s.NEXTVAL,

2056: last_update_date,
2057: last_updated_by,
2058: last_update_login)
2059: VALUES (
2060: fv_sf1219_temp_s.NEXTVAL,
2061: 0,
2062: 'NO FUND',
2063: 'P Batch',
2064: p_set_bks_id,

Line 3334: fv_sf1219_temp_s.nextval,

3330: last_update_login,
3331: je_header_id,
3332: je_line_num)
3333: VALUES(
3334: fv_sf1219_temp_s.nextval,
3335: l_batch_id,
3336: l_fund_code,
3337: l_name,
3338: p_set_bks_id,

Line 4058: fv_sf1219_temp_s.nextval,

4054: last_update_login,
4055: je_header_id,
4056: je_line_num)
4057: VALUES(
4058: fv_sf1219_temp_s.nextval,
4059: l_batch_id,
4060: l_fund_code,
4061: l_name_keep,
4062: p_set_bks_id,