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: /* BEGIN
905: SELECT lookup_code INTO l_cp_rec.rc_overlap
906: FROM fnd_lookups

Line 919: FROM SYS.DUAL;

915: NULL, 'N',
916: LTRIM (RTRIM (l_p_comp_plan_rec.rc_overlap))
917: )
918: INTO l_cp_rec.rc_overlap
919: FROM SYS.DUAL;
920:
921: --
922: -- Valid compensation plan
923: --