APPS.CN_PERIODS_API dependencies on CN_PERIOD_TYPES

Line 962: FROM cn_period_types

958: l_msg_data VARCHAR2(2000);
959:
960: CURSOR c1 IS
961: SELECT period_type_id
962: FROM cn_period_types
963: WHERE period_type = x_period_type
964: AND org_id = x_org_id;
965: CURSOR c2 IS
966: SELECT period_set_id

Line 994: -- get the period_type_id from cn_period_types,

990: ORDER BY Abs(cal_period_id - x_period_id);
991:
992: BEGIN
993:
994: -- get the period_type_id from cn_period_types,
995: -- if there is no matching record, create one
996: OPEN c1;
997: FETCH c1 INTO x_period_type_id;
998:

Line 1000: SELECT cn_period_types_s.NEXTVAL

996: OPEN c1;
997: FETCH c1 INTO x_period_type_id;
998:
999: IF (c1%NOTFOUND) THEN
1000: SELECT cn_period_types_s.NEXTVAL
1001: INTO x_period_type_id
1002: FROM dual;
1003: INSERT INTO cn_period_types
1004: (period_type_id,

Line 1003: INSERT INTO cn_period_types

999: IF (c1%NOTFOUND) THEN
1000: SELECT cn_period_types_s.NEXTVAL
1001: INTO x_period_type_id
1002: FROM dual;
1003: INSERT INTO cn_period_types
1004: (period_type_id,
1005: period_type,
1006: org_id)
1007: VALUES