APPS.CN_COMP_PLAN_PUB dependencies on DUAL

Line 129: FROM SYS.DUAL

125: -- Check if already assigned( duplicate assigned )
126: BEGIN
127: SELECT 1
128: INTO l_dummy
129: FROM SYS.DUAL
130: WHERE NOT EXISTS (
131: SELECT 1
132: FROM cn_quota_assigns
133: WHERE quota_id = x_pe_id

Line 852: FROM SYS.DUAL;

848: fnd_api.g_miss_char, NULL,
849: LTRIM (RTRIM (l_p_comp_plan_rec.NAME))
850: )
851: INTO l_cp_rec.NAME
852: FROM SYS.DUAL;
853:
854: SELECT DECODE (l_p_comp_plan_rec.start_date,
855: fnd_api.g_miss_date, NULL,
856: l_p_comp_plan_rec.start_date

Line 859: FROM SYS.DUAL;

855: fnd_api.g_miss_date, NULL,
856: l_p_comp_plan_rec.start_date
857: )
858: INTO l_cp_rec.start_date
859: FROM SYS.DUAL;
860:
861: SELECT DECODE (l_p_comp_plan_rec.end_date,
862: fnd_api.g_miss_date, NULL,
863: l_p_comp_plan_rec.end_date

Line 866: FROM SYS.DUAL;

862: fnd_api.g_miss_date, NULL,
863: l_p_comp_plan_rec.end_date
864: )
865: INTO l_cp_rec.end_date
866: FROM SYS.DUAL;
867:
868: SELECT DECODE (l_p_comp_plan_rec.description,
869: fnd_api.g_miss_char, NULL,
870: LTRIM (RTRIM (l_p_comp_plan_rec.description))

Line 873: FROM SYS.DUAL;

869: fnd_api.g_miss_char, NULL,
870: LTRIM (RTRIM (l_p_comp_plan_rec.description))
871: )
872: INTO l_cp_rec.description
873: FROM SYS.DUAL;
874:
875: SELECT DECODE (l_p_comp_plan_rec.plan_element_name,
876: fnd_api.g_miss_char, NULL,
877: LTRIM (RTRIM (l_p_comp_plan_rec.plan_element_name))

Line 880: FROM SYS.DUAL;

876: fnd_api.g_miss_char, NULL,
877: LTRIM (RTRIM (l_p_comp_plan_rec.plan_element_name))
878: )
879: INTO l_cp_rec.plan_element_name
880: FROM SYS.DUAL;
881:
882: SELECT DECODE (l_p_comp_plan_rec.org_id,
883: fnd_api.g_miss_char, NULL,
884: LTRIM (RTRIM (l_p_comp_plan_rec.org_id))

Line 887: FROM SYS.DUAL;

883: fnd_api.g_miss_char, NULL,
884: LTRIM (RTRIM (l_p_comp_plan_rec.org_id))
885: )
886: INTO l_cp_rec.org_id
887: FROM SYS.DUAL;
888:
889: -- Set status_code lookup code = INCOMPLETE
890: /* SELECT lookup_code INTO l_cp_rec.status
891: FROM cn_lookups

Line 902: FROM SYS.DUAL;

898: fnd_api.g_miss_char, 'No',
899: LTRIM (RTRIM (l_p_comp_plan_rec.rc_overlap))
900: )
901: INTO l_lk_meaning
902: FROM SYS.DUAL;
903:
904:
905: /* BEGIN
906: SELECT lookup_code INTO l_cp_rec.rc_overlap

Line 921: FROM SYS.DUAL;

917: fnd_api.g_miss_char, 'No',
918: LTRIM (RTRIM (l_p_comp_plan_rec.sum_trx))
919: )
920: INTO l_lk_meaning
921: FROM SYS.DUAL;
922:
923: SELECT DECODE (l_p_comp_plan_rec.rc_overlap,
924: fnd_api.g_miss_char, 'N',
925: NULL, 'N',

Line 929: FROM SYS.DUAL;

925: NULL, 'N',
926: LTRIM (RTRIM (l_p_comp_plan_rec.rc_overlap))
927: )
928: INTO l_cp_rec.rc_overlap
929: FROM SYS.DUAL;
930:
931: -- 7330382:R12.CN.B scannane
932: SELECT DECODE (l_p_comp_plan_rec.sum_trx,
933: fnd_api.g_miss_char, 'N',

Line 938: FROM SYS.DUAL;

934: NULL, 'N',
935: LTRIM (RTRIM (l_p_comp_plan_rec.sum_trx))
936: )
937: INTO l_cp_rec.sum_trx
938: FROM SYS.DUAL;
939:
940: --
941: -- Valid compensation plan
942: --