APPS.IEX_STATUS_RULE_PVT dependencies on IEX_CU_STS_RL_LINES

Line 552: FROM iex_cu_sts_rl_lines

548: WHERE STATUS_RULE_ID = IN_STATUS_RULE_ID;
549: --
550: CURSOR C_GET_Status_Rule_LineS (IN_STATUS_RULE_ID NUMBER) IS
551: SELECT Status_Rule_line_ID
552: FROM iex_cu_sts_rl_lines
553: WHERE STATUS_RULE_ID = IN_STATUS_RULE_ID;
554: --
555: l_status_rule_id NUMBER;
556: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Status_Rule';

Line 671: SELECT iex_cu_sts_rl_lines_s.nextval

667:
668:
669: IS
670: CURSOR get_seq_csr is
671: SELECT iex_cu_sts_rl_lines_s.nextval
672: FROM sys.dual;
673: --
674: l_api_name CONSTANT VARCHAR2(30) := 'Create_status_rule_line';
675: l_api_version_number CONSTANT NUMBER := 1.0;

Line 808: from iex_cu_sts_rl_lines

804: CREATION_DATE,
805: CREATED_BY ,
806: LAST_UPDATE_LOGIN,
807: OBJECT_VERSION_NUMBER
808: from iex_cu_sts_rl_lines
809: where status_rule_line_id = in_status_rule_line_id
810: FOR UPDATE NOWAIT;
811: --
812: l_api_name CONSTANT VARCHAR2(30) := 'Update_status_rule_line';

Line 982: FROM iex_cu_sts_rl_lines

978:
979: IS
980: CURSOR C_GET_status_rule_line (IN_status_rule_line_ID NUMBER) IS
981: SELECT rowid
982: FROM iex_cu_sts_rl_lines
983: WHERE status_rule_line_ID = IN_status_rule_line_ID;
984: --
985: l_status_rule_line_id NUMBER;
986: l_api_name CONSTANT VARCHAR2(30) := 'Delete_status_rule_line';