APPS.IGC_CBC_VALIDATIONS_PKG dependencies on IGC_CC_INTERFACE_V

Line 1504: FROM igc_cc_interface_v

1500: SELECT count(*)
1501: /*
1502: ,max(batch_line_num)
1503: */
1504: FROM igc_cc_interface_v
1505: WHERE budget_dest_flag ='C'
1506: AND cc_header_id = p_cc_head_id
1507: AND actual_flag = p_actl_flag
1508: AND document_type = p_documt_type;

Line 1512: FROM igc_cc_interface_v

1508: AND document_type = p_documt_type;
1509:
1510: CURSOR c_sbc_count IS --Check if SBC records in the interface table
1511: SELECT count(*)
1512: FROM igc_cc_interface_v
1513: WHERE budget_dest_flag = 'S'
1514: AND cc_header_id = p_cc_head_id
1515: AND actual_flag = p_actl_flag
1516: AND document_type = p_documt_type;

Line 1520: FROM igc_cc_interface_v

1516: AND document_type = p_documt_type;
1517:
1518: CURSOR c_sob_count IS -- Check sob in the table, must be 1 or 0
1519: SELECT count(DISTINCT set_of_books_id)
1520: FROM igc_cc_interface_v
1521: WHERE cc_header_id = p_cc_head_id
1522: AND actual_flag = p_actl_flag
1523: AND document_type = p_documt_type;
1524:

Line 1528: FROM igc_cc_interface_v

1524:
1525: /* THIS CHECK IS NOT REQIRED ANYMORE BECAUSE OF PA INTEGRATION
1526: CURSOR c_result_count IS --Check result code in the table, must be 0
1527: SELECT count(*)
1528: FROM igc_cc_interface_v
1529: WHERE cc_header_id = p_cc_head_id
1530: AND actual_flag = p_actl_flag
1531: AND document_type = p_documt_type
1532: AND ( cbc_result_code IS NOT NULL

Line 1538: FROM igc_cc_interface_v

1534: /*
1535: --R12 uptake. Encumbrance Details are seeded in R12. Bug No 6341012
1536: CURSOR c_enc_count IS --Check encumbrance_type_id Must be 0
1537: SELECT count(*)
1538: FROM igc_cc_interface_v
1539: WHERE cc_header_id = p_cc_head_id
1540: AND actual_flag = 'E'
1541: AND document_type = p_documt_type
1542: AND encumbrance_type_id IS NULL;

Line 1551: FROM igc_cc_interface_v

1547: --Packet ID does not exist in R12. Hence Commented. Bug No 6341012
1548: CURSOR c_cbc_count_packet IS --Check if CBC records in the interface table
1549: SELECT count(*),
1550: max(batch_line_num)
1551: FROM igc_cc_interface_v
1552: WHERE budget_dest_flag ='C'
1553: AND reference_6 = p_packet_id
1554: AND actual_flag = p_actl_flag ;
1555:

Line 1558: FROM igc_cc_interface_v

1554: AND actual_flag = p_actl_flag ;
1555:
1556: CURSOR c_sbc_count_packet IS --Check if SBC records in the interface table
1557: SELECT count(*)
1558: FROM igc_cc_interface_v
1559: WHERE budget_dest_flag = 'S'
1560: AND reference_6 = p_packet_id
1561: AND actual_flag = p_actl_flag ;
1562:

Line 1565: FROM igc_cc_interface_v

1561: AND actual_flag = p_actl_flag ;
1562:
1563: CURSOR c_enc_count_packet IS --Check encumbrance_type_id Must be 0
1564: SELECT count(*)
1565: FROM igc_cc_interface_v
1566: WHERE reference_6 = p_packet_id
1567: AND actual_flag = 'E'
1568: AND encumbrance_type_id IS NULL;
1569: */